Parsing Hive Create table query using Apache Hive library
Apache Hive Apache Hive is an open source data warehousing solution build on top of Hadoop. It supports SQL-like query
Continue readingCategory: Hadoop
How to rename a column in Hive?
Alter table statement in Hive The Alter table statement is used to change the structure of the existing table in
Continue readingTrim function in Hive with examples
Trim function in Hive Trim function removes the extra space from both ends of the string value. In other words,
Continue readingHow to write a Spark dataframe to Hive table in Pyspark?
Apache spark to write a Hive Table Apache Spark provides an option to read from Hive table as well as
Continue readingInstr 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 readingHow 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 reading