Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Build #: 47130
Built on: 2015-Nov-19 03:07:33 PM
OS:Windows 8
CREATE TABLE `default`.`sale` (`divisionid` tinyint)
PARTITIONED BY (sk_calendar int)
STORED AS ORC
TBLPROPERTIES ('orc.compress'='NONE')
2. Right Click on table, select Tools->ER Diagram Generator. Click on checkbox of 'Table' option. Select 'sale' table from Objects list. Click on 'Next'.
3. It is observed that partition column name is not displayed in table diagram.
|
|
82 KB
|
|
561 KB
|
2 KB
@laxdeep: you can do more research on this topic. See what other DBs we display partitions for in schema browser (for instance, Greenplum?) And then determine for those DBs, do we display the partition info in ER diagram. By having a more complete picture, it helps us make a more informed product decision.
@Sachin,
Below databases support partition by clause:
For these databases we need to use table column as partition column.
This is different from 'Hive'. In hive partitioned column is not the table column.
In other databases, partition column is included in table column. It is not displayed differently in ER Diagram.
For 'Hive' partition column is not the table column. So, can we display this column in table information along with table columns.
Please refer attached screenshot (Main.png) and text file (scripts.txt)
@Sachin,
Below databases support partition by clause:
For these databases we need to use table column as partition column.
This is different from 'Hive'. In hive partitioned column is not the table column.
In other databases, partition column is included in table column. It is not displayed differently in ER Diagram.
For 'Hive' partition column is not the table column. So, can we display this column in table information along with table columns.
Please refer attached screenshot (Main.png) and text file (scripts.txt)
We can only address this after adding Visual Editing support for Partitions in Hive
We can only address this after adding Visual Editing support for Partitions in Hive
Issue #13884 |
| New |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
depends upon #13790
Issue #13790Hive - Add support for partitions in create, alter and table property dialog. |
@laxdeep: you can do more research on this topic. See what other DBs we display partitions for in schema browser (for instance, Greenplum?) And then determine for those DBs, do we display the partition info in ER diagram. By having a more complete picture, it helps us make a more informed product decision.