Script(s)

technology as-is

August 28, 2015
by gchandra
0 comments

Hive : Create database in different folder

When database is created in Hive, its usually saved in default folder  /user/hive/warehouse/yourdabase.db If alternate location is needed, then create database <yourdatabase> location  ‘/db/path/yourdatabase.db’    [single quotes]  

August 17, 2015
by gchandra
0 comments

Hive Error : SemanticException TOK_ALLCOLREF

Hive Error :  SemanticException TOK_ALLCOLREF is not supported in current context Reason :  Select Distinct * From <tablename> Solution : Hive doesn’t support  distinct *, so  mention the column names Select Distinct col1, col2, col3… From <tablename>