How to split the string based on delimiter in Teradata
STRTOK function in Teradata STRTOK function is used to split the string into tokens based on the specified delimiter. It
Continue readingHow to replace string and its all occurrence with another string using bash
Bash supports number of string manipulation operations. It is providing the option to replace the given string to another string.
Continue readingPerformance tuning using Collect Statistics in Teradata table with examples
Collect Statistics in Teradata Collect statistics statement is collects the demographic data for one or more columns ,hash indexes ,
Continue readingHow to add the drop down list in a Excel cell
Drop Down list in Excel cell Drop down list contains the number of entries that are related to particular column
Continue readingHow to set the different execution engine in Hive with examples
Execution engine in Hive Execution Engine used to communicate with Hadoop daemons such as Name node, Data nodes, and job
Continue readingHow to grant the access on tables in Oracle
Grant Statement Grant statement is used to provide the access to specific users and It allows the user to perform
Continue readingHow to name the Primary indexes in Teraata table with examples
Primary Index in Teradata While we create the table in Teradata, we can specify the Primary index(PI) or Unique primary
Continue readingInsert 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 reading