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

Tag: SEQUENCE FILE FORMAT in Hive

Exploring Input File Formats – Part-2

2nd Jun 2021 SHAFI SHAIK

Before reading the below article, first read File Formats and Compression in Apache Hive & Exploring Input File Formats – Part-1. It’s a follow-up post

Continue reading

File formats and compression in Apache Hive

30th Sep 2020 SHAFI SHAIK

The purpose of this article is to address the different file formats and compression codecs in Apache Hive that are available for different data sets.

Continue reading

Categories

  • Apache Hive (282)
  • Apache Impala (158)
  • Apache Pig (42)
  • Apache Sqoop (28)
  • AWS RDS (51)
  • Bitnami (1)
  • Cloudera Impala (157)
  • DWH (2)
  • EC2 Jump Server (16)
  • Flume (1)
  • General (23)
  • HBase (1)
  • HDFS (26)
  • Hue (2)
  • Kubernetes (2)
  • Map Reduce (3)
  • MongoDB (14)
  • MySQL (160)
  • NoSQL (10)
  • Oracle SQL*Plus (23)
  • PostgreSQL (14)
  • ProxySQL (8)
  • RDBMS (13)
  • Spark & SparkSQL (10)
  • SQL Azure (7)
  • SQL Server (288)
  • SQL Server – XML (4)
  • SQL Server Functions (61)
  • Sqoop2 (4)
  • SSRS (18)
  • Triggers (4)

Archives

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

Join 1,611 other subscribers.

Blog Stats

  • 521,700 hits

Follow Us

  • LinkedIn
  • X
  • 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.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Big Data & SQL
    • Join 84 other subscribers.
    • Already have a WordPress.com account? Log in now.
    • Big Data & SQL
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...