How to split the string based on pattern in Hive
Split function in Hive Hive providing many string functions to manipulate the strings. Split is one of the string function
Continue readingCategory: Hadoop
How to set the different execution engine in Hive with examples
Execution engine in Hive Execution Engine used to communicate with Hadoop daemons such as Name node, Data nodes, and job
Continue readingInsert overwrite table values in Hive with examples
Insert overwrite table in Hive The insert overwrite table query will overwrite the any existing table or partition in Hive.
Continue readingHow to create a table with Partitions in Hive
Hive Partitions Partitioning is the way to dividing the table based on the key columns and organize the records in
Continue readingHow to write Group by and Order by query with column position number in Hive
Hive query with Group by and order by While we write the group by expression in Hive, we need to
Continue readingHow to use variables in Hive while run the queries?
hivevar option in Hive The hivevar option is used to create the custom variables and pass the values to the
Continue readingHow to count the number of lines in a HDFS file?
WC command wc(word count) command is used in Linux/Unix to find out the number of lines,word count,byte and character count
Continue readingHow to run one or more hive queries in a file using hive -f command
Hive -f command The Hive -f command is used to execute one or more hive queries from a file in
Continue readingHow to run a hive query from the command line using hive -e command
Hive -e command The Hive -e command is used to run the hive query in batch mode.Instead of enter into
Continue readingGet the create table statement for an existing Hive table using Show create table
The SHOW statement is a flexible way to get the information about existing objects in Hive. One of the Show
Continue reading
