Hiveql - RIGHT() LEFT() Function

string hive hiveql
jmich738 picture jmich738 · Jan 3, 2017 · Viewed 47.5k times · Source

Is there a function in Hiveql that is equivalent to Right() or Left() fuction form TSQL? For example, RIGHT(col1,10) to get the first 10 characters from col1.

thank you

Answer

sandeep rawat picture sandeep rawat · Jan 3, 2017

There is no right or left function but you can implement same with substr like

left (column, nchar) = substr(column, 1, nchar)

right  (column, nchar) = substr (column, (-1)* nchar)

Note: Here nchar is number of characters

Related questions

Hive: Convert String to Integer

I am looking for a Built-in UDF to convert values of a string column to integer in my hive table for sorting using SELECT and ORDER BY. I searched in the Language Manual, but no use. Any other suggestions also …

Read More
How can I convert array to string in hive sql?

I want to convert an array to string in hive. I want to collect_set array values to convert to string without [[""]]. select actor, collect_set(date) as grpdate from actor_table group by actor; so that [["2016-07-01", "2016-07…

Read More
Hive cast string to date dd-MM-yyyy

How can I cast a string in the format 'dd-MM-yyyy' to a date type also in the format 'dd-MM-yyyy' in Hive? Something along the lines of: CAST('12-03-2010' as date 'dd-mm-yyyy')

Read More