Skip to content

It's all about SQL Server, MySQL, Oracle SQL*Plus, PostgreSQL, NoSQL, Hbase, Apache Pig, Apache Hive, Apache Sqoop, HDFS, MapReduce, ProxySQL, EC2, AWS and MongoDB

  • 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
    • Complete TSQL with Examples
    • SQL Sample project
    • SQL Assignment-1
  • Courses
    • CCA Data Analyst CCA159
      • CCA159 Requirements
      • DDL For Databases & Tables
        • Complete DDL
        • DROP Database Commands
        • Extended Properties
        • Table Properties
        • Usage of ALTER
      • Creating Table From Existing
      • File formats and Compressions
      • Assignments To Prepare CCA159
    • Online Courses
  • General
  • Downloads
  • Contact Us
    • About
    • Write Guest Posts
    • Contact Us

Tag: Impala Miscellaneous Functions

Impala Miscellaneous Functions

10th Nov 2020 SHAFI SHAIK
Continue reading

Archives

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 998 other subscribers.

Categories

  • Apache Hive (281)
  • Apache Impala (157)
  • Apache Pig (42)
  • Apache Sqoop (28)
  • AWS RDS (47)
  • Bitnami (1)
  • Cloudera Impala (156)
  • DWH (2)
  • EC2 Jump Server (12)
  • Flume (1)
  • General (19)
  • HBase (1)
  • HDFS (26)
  • Hue (1)
  • Kubernetes (2)
  • Map Reduce (3)
  • MongoDB (13)
  • MySQL (149)
  • NoSQL (10)
  • Oracle SQL*Plus (22)
  • PostgreSQL (13)
  • ProxySQL (6)
  • RDBMS (12)
  • Spark & SparkSQL (10)
  • SQL Azure (7)
  • SQL Server (266)
  • SQL Server – XML (4)
  • SQL Server Functions (61)
  • Sqoop2 (4)
  • SSRS (4)

Blog Stats

  • 278,336 hits

Follow Us

  • LinkedIn
  • Twitter
  • Facebook
  • Tumblr
Apache Hive Course Contents

Apache Hive Course Contents

Apache Hive is built on top of Apache Hadoop, which…

Apache Sqoop Course Contents

Apache Sqoop Course Contents

This page combines all Sqoop-related topics into a single article…

Hive SerDe – RegEx

Here are several examples with explanations and sample datasets for…

Apache Impala – Step by Step

Apache Impala – Step by Step

Throughout the year, “Big Data & SQL” published a number…

HDFS Tutorial

HDFS Tutorial

Here are all of the HDFS articles that have been…

Apache Pig Tutorial

Apache Pig Tutorial

This page combines all Apache Pig related posts into a…

Blog at WordPress.com.
  • Follow Following
    • Big Data and SQL
    • Join 61 other followers
    • Already have a WordPress.com account? Log in now.
    • Big Data and SQL
    • Customise
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...