Instr function in Hive with examples
Hive instr function Instr is a string function which returns the position of the first occurrence of substring in the
Continue readingCategory: Hadoop
How to access a Hive table using Pyspark?
Pyspark Apache Spark is an in-memory data processing framework written in Scala language. It process the data 100 times faster
Continue readingHow to create a database at specific location in Hive?
Create database in Hive The database is an organised collection of tables.Hive has the default database with the name as
Continue readingHow to connect Hive using JDBC connection?
Hive JDBC Hive allows the applications to connect to it using the JDBC driver. JDBC driver uses Thrift to communicate
Continue readingHow to create a external table in Hive?
External Table in Hive When we create the table in Hive, we can define the type of a table. As
Continue readingHow to execute HiveQL queries using Shell script?
Introduction Shell script can be used to run the Hive queries in batch mode. It will handle the input values/arguments
Continue readingHow to create hourly partitions in Hive table
Hourly partitions in Hive table When we have large quantities of data, we look for partition column to improve the
Continue readingIf condition in Hive with examples
If condition/statement in Hive Hive supports many conditional functions such as If, isnull, isnotnull, nvl, nullif, COALESCE and CASE. The
Continue readingSum function with Case expression in Hive
Sum() function in Hive Sum is one of the Aggregate function that returns the sum of the values of the
Continue readingHow to get the HDFS file size using WebHDFS?
WebHDFS WebHDFS is a protocol which is based on an industry-standard RESTful mechanism. It provides the same functionality as HDFS,
Continue reading
