Skip to content
Blog
Apache Hive
Apache Hive Complete
Built-in Functions
Date Time Functions
More Date Time Functions
MORE
FROM_UNIXTIME
DATEDIFF
DATE_ADD
WEEKOFYEAR
HOUR
MINUTE
SECOND
EXTRACT
DATE_SUB
DAYOFMONTH
DATE_FORMAT
YEAR
QUARTER
MONTH
ADD_MONTHS
MONTHS_BETWEEN
UNIX_TIMESTAMP
DAY
TO_DATE
CURRENT_DATE
CURRENT_TIMESTAMP
NEXT_DAY
LAST_DAY
TRUNC
String Functions
More Functions
More Functions
SPLIT
STR_TO_MAP
SUBSTR
SUBSTRING_INDEX
TRANSLATE
TRIM
UPPER
SPACE
LPAD
LTRIM
PARSE_URL
PRINTF
REGEXP_EXTRACT
REPEAT
REPLACE
REVERSE
RPAD
RTRIM
CONCAT
CONCAT_WS
FORMAT_NUMBER
GET_JSON_OBJECT
INITCAP
INSTR
LENGTH
LOCATE
LOWER
Aggregate Functions
Aggregate Functions-1
Aggregate Functions-2
Aggregate in Analytic Context
Type Conversion Functions
Cast Function
Conditional Functions
CASE
IF ELSE
ISNULL
NVL
ISNULL vs NVL
COALESCE
IFNULL
ZEROIFNULL
Collection Functions
Table Generting Functions
Misc Functions
CURRENT_USER
LOGGED_IN_USER
CURRENT_DATABASE
VERSION
Complex Data Types
Complex Data Types-1
Complex Data Types-2
Complex Data Types-3
Complex Data Types-4
Complex Data Types-5
STRUCT within ARRAY -1
STRUCT within ARRAY -2
ARRAY within STRUCT
ARRAY within MAP-1
STRUCT within MAP-2
ARRAY in MAP
File Formats
TEXT FILE FORMAT
SEQUENCE FILE FORMAT
PAREQUET FILE FORMAT
AVRO FILE FORMAT
Optimized Row Columnar (ORC) File Format
Compression Algorithms For ORC
NON-SQL STATEMENTS
HIVE NON-SQL STATEMENTS
EXTENDED PROPERTIES
TABLE PROPERTIES
CLI COMMANDS
Executing HiveQL Script from CLI
Executing Scripts NON-INTERACTIVE MODE
DISPLAY COLUMN NAMES HIVE PROMPT
DISPLAY DATABASE NAME HIVE PROMPT
SHOW DATABASES
Internal Tables
Internal Tables in Hive β Part-1
Internal Tables in Hive β Part-2
Internal Tables in Hive β Part-3
Hive Internal Tables Using CTAS
External Tables
DDL COMMANDS
DDL COMMANDS
USAGE OF ALTER
JOINS
Hive SerDe RegEx
Hive SerDe Regular Expressions 1
Hive SerDe Regular Expressions 2
Hive SerDe Regular Expressions 3
Hive SerDe Regular Expressions 4
Hive SerDe Regular Expressions 5
Hive SerDe Regular Expressions 6
Hive SerDe Regular Expressions 7
Hive SerDe Regular Expressions 8
Hive SerDe Regular Expressions 9
Hive SerDe Regular Expressions 10
Hive SerDe Common Errors
Sqoop
SQOOP Complete Tutorial Part-1
SQOOP Complete Tutorial Part-2
SQOOP Complete Tutorial Part-3
SQOOP Complete Tutorial Part-4
SQOOP Complete Tutorial Part-5
SQOOP Complete Tutorial Part-6
SQOOP Complete Tutorial Part-7
SQOOP Complete Tutorial Part-8
SQOOP Complete Tutorial Part-9
SQOOP Complete Tutorial Part-10
SQOOP Complete Tutorial Part-11
Sqoop Complete Tutorial Part-12
Apache Sqoop Complete
SQL Server
SQL Server Functions
SQL Server New Functions
String Functions
REPLICATE
Parsing, Casting and Conversion
PARSENAME
STRING_AGG()
CASE
NVL, COALESCE(), ISNULL
String_Split
CHARINDEX
PATINDEX
STUFF
AGGREGATE FUNCTIONS
Aggregate Functions-1
Aggregate Functions-2
Aggregate Functions in Analytic Context
Date Time Functions
JSON_VALUE & JSON_QUERY
Analytical & Window Functions
Analytical & Window Functions
TOP, LIMIT, ROWNUM vs DENSE_RANK
NTILE
Computing Running & Cumulative Average
Database Development Posts
Hijri Date with Islamic Month
Reserved Keywords As Columns
Creating Linked Server for PostgreSQL
Insert Data From Linked Server
Logical vs Physical Computed Columns
Creating Table From Existing
Find Missing Serial Numbers
Multiple Columns With Default Value
Create table and view with SELECT
XML in SQL Server
XML in SQL Server
XML in SQL Server β Part-2
SQL Server β Data Export to XML
DB Mail
Sending Email Part-1
Sending Email Part-2
Sending Email Part-3
Import & Export
Import from Excel
Data Export to XML
Generate CSV Files
Database Administration
Database Objects
Last Modified Date β Stored Procedure
Get Procedures, Functions, Triggers
Get Table Row Count And Used Size
Find Column From Tables
SQL Server Agent
Alert on Scheduled Jobs
SQL Server Agent Status
Find Scheduled jobs
Troubleshoot
SQL Server Compatibility Issues
Search in Error Log
Get Active Node From Cluster
SQL Server β Reports
Disk Space Usage
Database Restore Info Report
Partitions
SQL Assignments
SQL Assignment-1
SQL Assignment-2
Answer to β SQL Assignment-2
SQL Assignment-3
Answer to β SQL Assignment-3
SQL Assignment-4
Answer to β SQL Assignment-4
Complete TSQL with Examples
SQL Sample project
SQL Server Complete
Courses
CCA Data Analyst (CCA159) Exam
CCA Data Analyst (CCA159) Exam
DDL For Databases & Tables
Assignments To Prepare CCA159
Online Courses
General
Downloads
Contact Us
About
Write Guest Posts
Contact Us
Nothing Found
Sorry, but nothing matched your search terms. Please try again with some different keywords.
Search for:
Search
Subscribe
Subscribed
Big Data & SQL
Join 80 other subscribers.
Sign me up
Already have a WordPress.com account?
Log in now.
Big Data & SQL
Customise
Subscribe
Subscribed
Sign up
Log in
Report this content
View site in Reader
Manage subscriptions
Collapse this bar
Loading Comments...
Write a Comment...
Email (Required)
Name (Required)
Website