Hi,
In my below query, there is no primary key(Sequential ID). Can we implement Incremental Load using some other field which not Primary Key?
Since I do not have primary key, I just want to concatenate the qvd file with new data (no updation and deletion of records) . Can I do concatenation without using "Where not exists(primary key)" in qvd load? Can I go ahead without using "Inner Join" (for deletion of records)?
Please help me.
//Metrics:
//LOAD
// num(replace(left("time_stamp",16),'T',' ')) as MetricTimestampKey,
// num(replace(left("time_stamp",16),'T',' ')) as DTE,
// //Floor(num(QV_TIMESTAMP)) as Date_DTE,
// time_stamp as TIME_STAMP,
// type as MetricType,
// field1 as FIELD1,
// field2 as FIELD2,
// field3 as FIELD3,
// field4 as FIELD4,
// field5 as FIELD5,
// field6 as FIELD6,
// field7 as FIELD7,
// field8 as FIELD8,
// field9 as FIELD9,
// field10 as FIELD10,
// if(type='2' or type='3' or type='4' or type='5' or type='8' or type='9' or type='11' or type='50' or type='51' or type='52', ApplyMap('Network_map',field1,field1), field1) as AllNetworkType,
// if(type='2' or type='4', ApplyMap('Network_status_map',field2,field2),field2) as AllNetworkStatus,
// if(type='4', ApplyMap('Network_status_map',field3,field3),field3) as AllNetworkStatus2,
// if(type='3', ApplyMap('Update_status_map',field2,field2),field2) as AllUpdateStatus,
// if(type='12', ApplyMap('Exception_type_map',field1,field1),field1) as AllExceptionType;
// SQL SELECT * FROM HIVE.gls."metrics_ext";
//