- Learning Computer Science and Programming

How 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

HTML table The <table> tag is defines the table in HTML. In that table, <thead> tag is used to define

Regexp_substr function in Teradata Teradata supports substring function to extract a portion of the string. But It doesn’t allow regular

Introduction Shell script can be used to run the Hive queries in batch mode. It will handle the input values/arguments

Hourly partitions in Hive table When we have large quantities of data, we look for partition column to improve the

If condition/statement in Hive Hive supports many conditional functions such as If, isnull, isnotnull, nvl, nullif, COALESCE and CASE. The

Sum() function in Hive Sum is one of the Aggregate function that returns the sum of the values of the

Unused tables in Teradata In general, DBA team in the Organization allocate limited amount of Teradata space for each user(individual/batch

WebHDFS WebHDFS is a protocol which is based on an industry-standard RESTful mechanism. It provides the same functionality as HDFS,

Show databases like query in Hive Show databases or Show schemas statement is lists all the database names in Hive