Reply
New Contributor
Posts: 1
Registered: ‎09-11-2018

Hive table lineage view is not displaying lineage info

Hi,

 

I am using CDH 5.14 enterprise trial version with cloudera navigator.

I am going through online documentation to explore navigator data lineage features.

I have created a hive table 'low_salaried_emp' from an existing hive table 'employees' and expecting navigator to display lineage of hive tables but lineage view doesn't display any lineage related info.

 

Posting my hive DDL below,

 

CREATE TABLE IF NOT EXISTS employees
(
name String
, age int
, dept String
, salary int
, city String
)
COMMENT 'Employee details'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

 

create table low_salaried_emp as select name,salary from employees where salary < 1000;

 

-------------------------------------------------------------------------------------------------------------------------------------

 

I tried with one more example, that's also not working.

 

 create table sam1(name String,salary int);

 

 insert overwrite table sam1 select name,salary from employees where salary > 1000;

 

Here navigator should display lineage info for entity 'sam' but in my case, it's not displaying anything.

 

Do I need to enable some property for data lineage to be shown ?

 

Or is it not possible with enterprise trial version and need paid subscription.

 

Thanks.

Deepak

Announcements