.hiverc file

gistfile1.sql

-- Load JSON Serde
add jar /home/haddop/lib/hive-serdes-1.1-SNAPSHOT.jar;

-- Print column names when stdout
set hive.cli.print.header=true;

-- Print current db at prompt hive (etl)>
set hive.cli.print.current.db=true;

-- Allow Hive to swith to Local Mode (without hadoop)
set hive.exec.mode.local.auto=true;

set hive.auto.convert.join=true;
set hive.mapjoin.smalltable.filesize=30000000;