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 readingPlease fill the quick survey to improve the quality of the articles. Cick here
Hive instr function Instr is a string function which returns the position of the first occurrence of substring in the
Continue readingPyspark 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 A Join statement is used to combine data or rows from two or more tables based
Continue readingCreate database in Hive The database is an organised collection of tables.Hive has the default database with the name as
Continue readingHive JDBC Hive allows the applications to connect to it using the JDBC driver. JDBC driver uses Thrift to communicate
Continue readingDocker image A Docker image is an executable package that includes everything needed to run a container: the code, a
Continue readingExternal Table in Hive When we create the table in Hive, we can define the type of a table. As
Continue readingHTML 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 Teradata supports substring function to extract a portion of the string. But It doesn’t allow regular
Continue readingIntroduction Shell script can be used to run the Hive queries in batch mode. It will handle the input values/arguments
Continue reading