Created 12-23-2016 01:34 AM
I am using hdinsight cluster with hdp 2.4 , table are storage in hive (blob storage) and qlik sene dash board pulls the hive table data which are partitioned by year,zode.
unfortunately we got some unnecessary zone and year data ..how can i deleted this data
I have try to drop the particular partitions using zone and year , while trigger hive we cont get the data but this data still exist in qlik sense dash board
Created 12-23-2016 05:00 AM
Created 12-23-2016 07:31 AM
Created 12-23-2016 08:02 AM
@rama it could be a problem iwth qlik sense, if you drop a partition of the table and qlik view is still able to see the data from that partition. I m not sure how qlik sense work but you should try refreshing the view or regenerate view
Created 12-23-2016 09:46 AM
Thank you once again@Rajkumar Singh
Can you tell me how to restore my drooping partition in hive table?
Is this correct process for recover old partitions MSCK REPAIR TABLE backup_db.bkp_table;
or is any other process is there?
We have using sqoop incremental for daily load into original table;
Created 12-23-2016 09:49 AM
Hi @Rama. I believe that Qlik caches data. You will want to check that the Qlik cache is cleared - or that your Qlik results are refreshed/rebuilt. I'm not sure of the specific way to do that... but ensure that your Qlik data is "fresh."