Insert overwrite table values in Hive with examples
Insert overwrite table in Hive The insert overwrite table query will overwrite the any existing table or partition in Hive.
Continue readingHow to create a table with Partitions in Hive
Hive Partitions Partitioning is the way to dividing the table based on the key columns and organize the records in
Continue readingHow to write Group by and Order by query with column position number in Hive
Hive query with Group by and order by While we write the group by expression in Hive, we need to
Continue readingHow to extract the substring from the value of a column in Teradata?
Substring() function in Teradata Substring function is used to extract a portion of a string from the value of a
Continue readingHow to find duplicates in a Teradata table
We can use GROUP BY clause to find how many times the value is duplicated in a table. Group by
Continue readingDelete a node at a given position in a Linked list C++
Steps to delete a node in a Linked List In order to delete a node at a given position in
Continue readingHow to find number of AMPs used in the Teradata Database system?
AMPs (Access Module Processor) in Teradata Access Module Processor(AMP) is a virtual processor(vproc) that used to stores and retrieve the
Continue readingHow to use variables in Hive while run the queries?
hivevar option in Hive The hivevar option is used to create the custom variables and pass the values to the
Continue readingHow to find all the tables created by specific user in Teradata?
Meta data tables in DBC database: Teradata meta data tables are stored in DBC database.The table level information present in
Continue readingHow to get the column names and data types of a table in Oracle database
Method 1: ALL_TAB_COLUMNS ALL_TAB_COLUMNS is a view in Oracle that contains the information about all columns in all table. We
Continue reading