[ATLAS-1642] Incorrect edges created when creating external hive table with partition keys

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 0.8-incubating
• Component/s: atlas-core
• Assignee: Unassigned
• Reporter: Sarath Subramanian
• Created: 06/Mar/17 09:46
• Updated: 06/Mar/17 19:26
• Resolved: 06/Mar/17 19:26

Description

1. Create external hive table with partition keys in beeline:-

create EXTERNAL table sampleTable1(id int, name string) comment 'table comment' partitioned by(dt string) location '/user/hive/data/someTestPath';

2. Check the hive table 'sampleTable1' entity in atlas UI:
a. Partition key column 'dt' is duplicated in columns property and status is deleted.

On investigating the vertex and edges of the table:
1. Table vertex has incorrect edge values for:
hive_table.columns - has partitionkey edge here (which shouldn't be stored here)

2. There is 3 outgoing edges from table to partition key column instead of one.

3. The status of partition key column is 'DELETED'

This results in failure of IT: HiveHookIT.testAlterTablePartitionColumnType()

Issue Links

• duplicates: ATLAS-1636 Hive partitions are showed as Columns in addition to hive columns in /api/atlas/entities response and in Atlas UI.