incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mehant Baid <baid.meh...@gmail.com>
Subject Re: Error in running select over hdfs
Date Fri, 24 Oct 2014 00:31:43 GMT
By default drill writes its logs to /var/log/drill, could you provide 
the relevant log information? You can grep the log files based on the 
query id returned as part of the error to the sqlline, in your case

[b6f84bc1-8f18-42e9-b79f-c889fa13a40e]


Thanks
Mehant
On 10/23/14, 5:10 PM, Mohit Anchlia wrote:
> I moved the file to .json and now I get:
>
> 0: jdbc:drill:zk=local> select * from `tweets-0.json`;
> Query failed: Screen received stop request sent. null
> [b6f84bc1-8f18-42e9-b79f-c889fa13a40e]
> Error: exception while executing query: Failure while trying to get next
> result batch. (state=,code=0)
>
> On Thu, Oct 23, 2014 at 11:28 AM, Abhishek Girish <abhishek.girish@gmail.com
>> wrote:
>> Or if your data is indeed in json format, change the extension of your data
>> file from ".txt" to ".json"
>>
>> On Thu, Oct 23, 2014 at 11:25 AM, Abhishek Girish <
>> abhishek.girish@gmail.com
>>> wrote:
>>> Can you try replacing "storageformat": "json" with "storageformat": "csv"
>>> ‚Äčin your plugin‚Äč
>>> ?
>>>
>>>
>>> On Thu, Oct 23, 2014 at 11:11 AM, Mohit Anchlia <mohitanchlia@gmail.com>
>>> wrote:
>>>
>>>> I've tried that too
>>>>
>>>> Error: exception while executing query: Failure while trying to get next
>>>> result batch. (state=,code=0)
>>>> 0: jdbc:drill:zk=local> select * from hdfs.json.`/tweets-0.txt`;
>>>> Oct 23, 2014 2:10:40 PM org.eigenbase.sql.validate.SqlValidatorException
>>>> <init>
>>>> SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table
>>>> 'hdfs.json./tweets-0.txt' not found
>>>> Oct 23, 2014 2:10:40 PM org.eigenbase.util.EigenbaseException <init>
>>>> SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1,
>> column
>>>> 15 to line 1, column 18: Table 'hdfs.json./tweets-0.txt' not found
>>>> Query failed: Failure while parsing sql. Table 'hdfs.json./tweets-0.txt'
>>>> not found [619f0469-0606-4e8e-9ae5-17a305f527fe]
>>>> Error: exception while executing query: Failure while trying to get next
>>>> result batch. (state=,code=0)
>>>> 0: jdbc:drill:zk=local>
>>>>
>>>> On Thu, Oct 23, 2014 at 11:04 AM, Neeraja Rentachintala <
>>>> nrentachintala@maprtech.com> wrote:
>>>>
>>>>> can you just try this.
>>>>> select * from hdfs.json.`/tweets-0.txt`;
>>>>>
>>>>> On Thu, Oct 23, 2014 at 10:59 AM, Mohit Anchlia <
>> mohitanchlia@gmail.com
>>>>> wrote:
>>>>>
>>>>>> This is what I see, looks like that file is showing up
>>>>>>
>>>>>> sqlline version 1.1.6
>>>>>> 0: jdbc:drill:zk=local> use hdfs.json;
>>>>>> +------------+------------+
>>>>>> |     ok     |  summary   |
>>>>>> +------------+------------+
>>>>>> | true       | Default schema changed to 'hdfs.json' |
>>>>>> +------------+------------+
>>>>>> 1 row selected (1.112 seconds)
>>>>>> 0: jdbc:drill:zk=local> show files
>>>>>> . . . . . . . . . . . > ;
>>>>>>
>>>>>>
>> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
>>>>>> |    name    | isDirectory |   isFile   |   length   |   owner  
 |
>>>>>> group    | permissions | accessTime | modificationTime |
>>>>>>
>>>>>>
>> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
>>>>>> | tweets-0.txt | false       | true       | 2097437    | root
>>   |
>>>>>> supergroup | rw-r--r--   | 2014-10-22 19:26:15.458 | 2014-10-22
>>>>>> 14:04:26.585 |
>>>>>> | tweets-1.txt | false       | true       | 1998156    | root
>>   |
>>>>>> supergroup | rw-r--r--   | 2014-10-22 14:04:26.616 | 2014-10-22
>>>>>> 14:04:37.123 |
>>>>>>
>>>>>>
>> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
>>>>>> 2 rows selected (0.264 seconds)
>>>>>> 0: jdbc:drill:zk=local>
>>>>>>
>>>>>> On Thu, Oct 23, 2014 at 10:56 AM, Jason Altekruse <
>>>>>> altekrusejason@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Could you try running 'show files' from the sqllline prompt to
see
>>>> if
>>>>>> that
>>>>>>> gives you any results for files Drill is able to find?
>>>>>>>
>>>>>>> On Thu, Oct 23, 2014 at 10:43 AM, Mohit Anchlia <
>>>>> mohitanchlia@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Could somebody look at this error and advise what might be
>> wrong?
>>>> It
>>>>>>> seems
>>>>>>>> I am doing everything that's documented.
>>>>>>>> On Wed, Oct 22, 2014 at 2:20 PM, Mohit Anchlia <
>>>>> mohitanchlia@gmail.com
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> I am getting the following error even though that file
exists
>> in
>>>>> hdfs
>>>>>>>>> 0: jdbc:drill:zk=local> select * from
>>>>>>>>> hdfs.`/user/train/xd/tweets/tmp/tweets-0.txt`;
>>>>>>>>> Oct 22, 2014 5:16:31 PM
>>>>>>> org.eigenbase.sql.validate.SqlValidatorException
>>>>>>>>> <init>
>>>>>>>>> SEVERE: org.eigenbase.sql.validate.SqlValidatorException:
>> Table
>>>>>>>>> 'hdfs./user/train/xd/tweets/tmp/tweets-0.txt' not found
>>>>>>>>> Oct 22, 2014 5:16:31 PM org.eigenbase.util.EigenbaseException
>>>>> <init>
>>>>>>>>> SEVERE: org.eigenbase.util.EigenbaseContextException:
From
>> line
>>>> 1,
>>>>>>> column
>>>>>>>>> 15 to line 1, column 18: Table
>>>>>>>>> 'hdfs./user/train/xd/tweets/tmp/tweets-0.txt' not found
>>>>>>>>> Query failed: Failure while parsing sql. Table
>>>>>>>>> 'hdfs./user/train/xd/tweets/tmp/tweets-0.txt' not found
>>>>>>>>> [7e1d5c73-0521-480e-b74b-a4fa50e3f4a7]
>>>>>>>>> Error: exception while executing query: Failure while
trying
>> to
>>>> get
>>>>>>> next
>>>>>>>>> result batch. (state=,code=0)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> I created new plugin called hdfs.
>>>>>>>>>
>>>>>>>>> {
>>>>>>>>>    "type": "file",
>>>>>>>>>    "enabled": true,
>>>>>>>>>    "connection": "hdfs://10.225.156.201:9000/",
>>>>>>>>>    "workspaces": {
>>>>>>>>>      "json": {
>>>>>>>>>        "location": "/user/train/xd/tweets/tmp",
>>>>>>>>>        "writable": false,
>>>>>>>>>        "storageformat": "json"
>>>>>>>>>      }
>>>>>>>>>    },
>>>>>>>>>    "formats": {
>>>>>>>>>      "json": {
>>>>>>>>>        "type": "json"
>>>>>>>>>      }
>>>>>>>>>    }
>>>>>>>>> }
>>>>>>>>>
>>>


Mime
View raw message