hiveql

Similar to how fsckstands for filesystem consistency check, msck is Hive’s metastore consistency check.

Yeah we can do that. You just need to follow below three commands in sequence. Lets say you have a external table test_1 in hive. And you want to rename it test_2 which should point test_2 location not test_1. Then you need to convert this table into Managed table using below command. test_1 -> pointing … Read more

You cannot add a column with a default value in Hive. You have the right syntax for adding the column ALTER TABLE test1 ADD COLUMNS (access_count1 int);, you just need to get rid of default sum(max_count). No changes to that files backing your table will happen as a result of adding the column. Hive handles … Read more

Yes, here you can use LIMIT. You can try it by the below query: SELECT * FROM employee_list SORT BY salary DESC LIMIT 2

datediff(to_date(String timestamp), to_date(String timestamp)) For example: SELECT datediff(to_date(‘2019-08-03’), to_date(‘2019-08-01’)) <= 2;

To get this you can use hive’s property which is TBLPROPERTIES (“skip.header.line.count”=”1”) you can also refer example – CREATE TABLE temp ( name STRING, id INT ) row format delimited fields terminated BY ‘\t’ lines terminated BY ‘\n’ tblproperties(“skip.header.line.count”=”1”);