Category Archives: Hive

Query Hive table from Pig – using HCatalog

Querying hive table from PIG using HCatalog $cat hcatScript.pig A = LOAD 'db1.tablename' USING org.apache.hcatalog.pig.HCatLoader(); B = LIMIT A 10; dump B; $pig -useHCatalog -f hcatScript.pig Comment below if you find this blog useful.

Hive Cheat Sheet

Hive CLI will soon be deprecated in favor of Beeline. Check here for beeline commands. Enter into hive shell by typing $hive hive> Hive Shell Commands Description Command Autocomplete hive> Press Tab key Display all 436 possibilities? (y or n) If you enter y, you’ll get a long list of all the keywords Navigation Keystrokes… Read More »