Case Statement in Hive with examples
Case Statement in Hive Hive supports Case statements to check the conditions against the column values. If any of the
Continue readingHow to get the Current Date in Hive with examples
Current date in Hive Hive provides many date functions to handle the date and time values in the tables. Current_date
Continue readingHow to calculate the Mean?
What is mean? Mean is defined as add the set of numbers , then divide the result by the count
Continue readingHow to import excel data into Teradata table?
Import data using Teradata SQL Assistant Teradata SQL assistant is providing the import data option which is used to bring
Continue readingTimestamp to Date conversion in Teradata
Data types in Teradata Timestamp and Date are different data types in Teradata. Each of them used for specific purpose
Continue readingHow to export/download the HTML table to Excel using Javascript?
HTML table HTML providing the <table> tag to show the data in row and column format. We might have seen
Continue readingHow to create Partitioned primary index in Teradata?
Partitioned primary index in Teradata Partitioning is an indexing technique in Teradata which helps to improve the query performance on
Continue readingCreate table with checkbox using Bootstrap
In this tutorial, we are going to create the basic table with check box using bootstrap. Bootstrap has a set
Continue readingAdd days to Date in Oracle with examples
Add days to Date in Oracle Add days is required to calculate the future dates in Database. Oracle allows us
Continue readingHow to rename a table in Hive?
Alter table statement in Hive Alter table statement helps to change the structure of the table in Hive. It allows
Continue reading