I am trying to delete a part of a string in HIVE. I want to delete the last eleven characters for all records in a column. The data looks like: 1018492743|0001-01-01 I want it to look like: 1018492743 The code I have tried looks like: Select right(a.ord_id, len(a.ord_id)-ll) It isn’t working because len isnt a function in HIVE Another issue
Tag: hadoop
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
query hbase like normal sql
I know Hbase is not like normal SQL. But is it possible to query Hbase something like this? select row-key from Table where cf:first=”ram” and cf:middle=”leela” and cf:last=”ban”; // ram(first …