Could you please share screenshots of the Instance tab from both Hive and Hive on Tez services? Based on our experience, the following action should resolve the issue.   Stop and delete the "HiveServer2" and "WebHCat" instances from Cloudera Manager > Hive > Instances Check that the role "HiveServer2" is present in Cloudera Manager > Hive on Tez > Instances Verify the Configuration page for 'Hive on Tez'; ensure that 'Hive Metastore Connector' is pointed at the Hive service that is running the Hive Metastore Restart the stale services ... View more

@Ganeshk Yes, we do not have any flag equivalent to -v in beeline. However, if we are looking for the command itself, you could find it in the line stating "Compiling command" or "Executing command" ... View more

Hi @smruti  Thanks for the reply. I forgot to post this but I also figured out that what you mentioned above is the actual problem the table was created in hive and as a result can not be modified by a spark instance. ... View more

Thanks for support, i done the same. ... View more

@saicharan This fails with the authentication error.  HTTP Response Code : 401 Verify the authentication details you are passing in the Adapter configuration ... View more

Hi @d_liu   Could be you took restart of HS2 but didn't logged in again from Hue, could be it is using same session. But HS2 restart should solve your problem. ... View more

@lysConsulting Have you ticked Kudu checkbox under Hive configuration in Cloudera Manager UI? Refer to: https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/kudu_hms.html#concept_enable_hms https://cwiki.apache.org/confluence/display/Hive/Kudu+Integration   In CDP : https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/kudu-hms-integration/topics/kudu-hms-enabling.html ... View more

@hanumanth, Have the replies helped resolve your issue? If so, can you please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future? ... View more

Which version are you on? Is this Cloudera Hive distribution?  I think UPDATE command is not working because it is not an acid(transactional) table. For update command to work, it has to be an ACID table. @roti  ... View more

@Shawn Here is a small example on how to find out what's the percentage of NOT NULL value of column maker:   select ((tot_cnt - a.null_maker)/tot_cnt)*100 as pcnt_not_null_maker from (select count(maker) as null_maker from used_cars where maker is NULL) a Left outer join (select count(*) as tot_cnt from used_cars) b   You may try this for all individual columns. ... View more