Category "hive"

How can I select rows where keeping only those that meet this criteria? sql/hive

I have a table like the following: +-------+------+ |ID |lang | +-------+------+ |1 |eng | |1 |pol | |2 |eng | |3 |gro | |

Convert string into binary in Hive

I want to match user ids from two tables in Hive. Unfortunately they are stored in different formats. In one table they are binary whereas in the second table t

How to load csv file in hive table?

I create table in hive and load csv file also from hdfs but when try to perform select query on created table I am getting results in encrypted format, can you

Use named_struct function in Hive with all the columns of a table

In Hive, you can use a function named_struct in order to create a list of key value pairs; the keys are usually the column names and the values are the values i