Skip to content
Advertisement

Tag: hive

Time difference between two date fields

I have a date field names “dts” in string format. I want to find out all the records based on their time differences (in hours). The run event time should be greater than or equal to eat event. The output should be: Answer Convert timestamps to seconds, then subtract, divide result by 3600 to get hours, use case+count to count

Concat multiple rows with a delimiter in Hive

I need to concat string values row wise with ‘~’ as delimiter. I have the following data: I need to concat ‘Comment’ column for each ‘id’ in the ascending order of ‘row_id’ with ‘~’ as delimiter. Expected output is as below: GROUP_CONCAT is not an option since its not recognized in my Hive version. I can use collect_set or collect_list,

Hive describe extended table return json

Is there any way to run “describe extended table” in Hive and have the results returned in JSON, XML, or some easily parsed format? Or is there an existing parse in Java that can parse this type of …

How to trim leading zero in Hive

How to trim leading zero in Hive, I search too much on google but I didn’t get any correct thing which is useful for my problem. If digit is “00000012300234” want result like “12300234” Answer nothing to do just cast the string in INT it will return 12300234

Hive Insert Overwrite Table

I’m new to Hive and I wanted to know if insert overwrite will overwrite an existing table I have created. I want to filter an already created table, let’s call it TableA, to only select the rows where …

Advertisement