Re: Issue in executing query on Drill Cluster

2017-10-18 Thread Khurram Faraaz
017 11:53:40 PM To: user@drill.apache.org Subject: RE: Issue in executing query on Drill Cluster HI Khurram I have given permission 777 to file /datalake/replicator/testdemo2. I am connecting to Drill with default user. But default user is different in both cases. Is it creating issue?

RE: Issue in executing query on Drill Cluster

2017-10-18 Thread Chetan Kothari
[mailto:kfar...@mapr.com] Sent: Wednesday, October 18, 2017 12:18 PM To: user@drill.apache.org Subject: Re: Issue in executing query on Drill Cluster Hi Chetan, 1. What are the permissions to the file /datalake/replicator/testdemo2 ? 2. Are you connecting as the same user to Drill

Re: Issue in executing query on Drill Cluster

2017-10-18 Thread Khurram Faraaz
<chetan.koth...@oracle.com> Sent: Tuesday, October 17, 2017 9:43:42 PM To: user@drill.apache.org Subject: Issue in executing query on Drill Cluster HI All When I am firing following query against dataset present in alluxio from embedded-drill, it is working normally.

Issue in executing query on Drill Cluster

2017-10-17 Thread Chetan Kothari
HI All When I am firing following query against dataset present in alluxio from embedded-drill, it is working normally. select REQ_HIST_REQUISITION_NUMBER, CONVERT_FROM(REQ_HIST_CREATION_DATE,'UTF8') AS REQ_HIST_CREATION_DATE , CONVERT_FROM(REQ_HIST_END_DATE,'UTF8') AS