How 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 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 find the unused tables in Teradata?
Unused tables in Teradata In general, DBA team in the Organization allocate limited amount of Teradata space for each user(individual/batch
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 readingFind list of databases/tables with specific pattern in Hive
Show databases like query in Hive Show databases or Show schemas statement is lists all the database names in Hive
Continue readingLength function in Hive with examples
Length function in Hive The length function returns the length of a specified string. In other words, it gives the
Continue reading