@oblamine As this is an older post you would have a better chance of receiving a resolution by starting a new thread. This will also provide the opportunity to provide details specific to your environment that could aid others in providing a more accurate answer to your question.  ... View more

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

@manuspark3 @SupriyaPS    If scale is not specified, it defaults to 0 . If no precision is supplied , it defaults to 10. Yes decimal works without precison.  ... View more

Hi,   Could you please try by creating external table on top of master directory and setting up below hive properties and read the table in HiveContext.   SET mapred.input.dir.recursive=true; SET hive.mapred.supports.subdirectories=true;   I hope, this will work.   Thanks, Manu ... View more