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 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 readingLeft join in Oracle with examples
LEFT JOIN in Oracle A Join statement is used to combine data or rows from two or more tables based
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 copy Docker image from one machine to another?
Docker image A Docker image is an executable package that includes everything needed to run a container: the code, a
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 merge the table cells in HTML?
HTML table The <table> tag is defines the table in HTML. In that table, <thead> tag is used to define
Continue readingRegexp_substr function in Teradata with examples
Regexp_substr function in Teradata Teradata supports substring function to extract a portion of the string. But It doesn’t allow regular
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