Skip to content

Instantly share code, notes, and snippets.

View kzhangkzhang's full-sized avatar

Kevin Zhang kzhangkzhang

13 followers · 34 following
View GitHub Profile
@kzhangkzhang
kzhangkzhang / BIGDATA_HIVE_CLI.md
Last active November 3, 2018 03:12
Hive Common Line Cheat Sheet

This document the common usage of the HIVE command line

Run Query

hive -e 'SELECT a.col from tabl1 a'

Run Query in Silent mode

@kzhangkzhang
kzhangkzhang / BIGDATA_HIVE_setting.md
Last active November 6, 2018 03:24
common Hive setting cheat sheet

Common Hiving Setting group by category

Dynamic Partition

Enable/Disable dynmaic partition inserts

  • hive.exec.dyanamic.partition=true

    ==> whether or not to allow dynamic partitions in DML/DDL

@kzhangkzhang
kzhangkzhang / BIGDATA_HIVE_hiverc.md
Last active November 3, 2018 01:26
Example HiveRC File to configure Hive Preference

What is HiveRC file?

It is a file that is executed when you launch the hive shell - making it an ideal place for adding any hive configuration/customization you want set, on start of the hive shell. This could be:

  • Setting column headers to be visible in query results
  • Making the current database name part of the hive prompt
  • Adding any jars or files
  • Registering UDFs

When you should consider to create and use HiveRC file?