Hi,   it does not work and gives me following error   SELECT DISTINCT `date` FROM mydb.syscal; Query: SELECT DISTINCT `date` FROM mydb.syscal Query submitted at: 2018-12-16 11:54:55 (Coordinator: https://host:port) ERROR: AnalysisException: Unsupported type 'DATE' in '`date`'.   Any other options?    Thanks & Regards, Kamleshkumar Gujarathi Bigdata Consultant   ... View more

Hi Team, I am trying to print output along with number records selected or number record affected messages in the output file but I am unable to print it. I have tried with --verbose=true also but it is not helping. <p> beeline -u "jdbc:hive2://abc.nsroot.net:10000/;principal=hive/abc.nsroot.net@ABC.NSROOT.NET;ssl=true " -f /home/test1.hql > testresult1.txt </p> hql files has only one query "select * from mytable;" can any one suggest me on this? Thanks & regards, Kamleshkumar Gujarathi ... View more

Hi Team, You can cast as decimal and solve the issue as shown below. ROUND(CAST(1.750646377E7 AS DECIMAL(38,10)),2); Thanks & regards, Kamleshkumar Gujarathi ... View more