In case you are doing it from Windows you can use Python script hivehoney to extract table data to local CSV file. It will: Login to bastion host. pbrun. kinit. beeline (with your query). Save echo from beeline to a file on Windows. Execute it like this: set PROXY_HOST=your_bastion_host set SERVICE_USER=you_func_user set LINUX_USER=your_SOID set LINUX_PWD=your_pwd python hh.py --query_file=query.sql ... View more

Returned 15 row(s) in 0.39s [localhost.localdomain:21000] > create table emp2 AS > select name,dept,job from svk.emp; Query: create table emp2 AS select name,dept,job from svk.emp ERROR: AnalysisException: Syntax error at: create table emp2 AS select name,dept,job from svk.emp ^ Encountered: AS Expected: LIKE CAUSED BY: Exception: Syntax error [localhost.localdomain:21000] > create table emp2 LIKE select name,dept,job from svk.emp; Query: create table emp2 LIKE select name,dept,job from svk.emp ERROR: AnalysisException: Syntax error at: create table emp2 LIKE select name,dept,job from svk.emp ^ Encountered: SELECT Expected: IDENTIFIER CAUSED BY: Exception: Syntax error [localhost.localdomain:21000] > create table emp2 LIKE emp; Query: create table emp2 LIKE emp [localhost.localdomain:21000] > create table emp2 AS select name,dept,job from svk.emp; Query: create table emp2 AS select name,dept,job from svk.emp ERROR: AnalysisException: Syntax error at: create table emp2 AS select name,dept,job from svk.emp ^ Encountered: AS Expected: LIKE CAUSED BY: Exception: Syntax error [localhost.localdomain:21000] > create table emp3 as select name,dept from emp; Query: create table emp3 as select name,dept from emp ERROR: AnalysisException: Syntax error at: create table emp3 as select name,dept from emp ^ Encountered: AS Expected: LIKE i have followed as you said, but it is giving below errors ... View more