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>  

August 12, 2014
by gchandra
0 comments

Special or Random characters on PuTTy screen

Recently I have been noticing some weird special characters on my PuTTy screen.  There was no pattern to it. It will appear all of a sudden. Its so annoying when you are working on a script. ex: ^[[28~ Reason : To … Continue reading