08, 2015 2:44 PM
To: 'user@drill.apache.org'
Subject: RE: Unable to query data from hdfs
Hope this link works.
https://drive.google.com/folderview?id=0ByB1-EsAGxA8MkhIdF9qczdBWFU&usp=sharing
Regards,
Latha
From: Sivasubramaniam, Latha
Sent: Wednesday, April 08, 2015 2:0
Hope this link works.
https://drive.google.com/folderview?id=0ByB1-EsAGxA8MkhIdF9qczdBWFU&usp=sharing
Regards,
Latha
From: Sivasubramaniam, Latha
Sent: Wednesday, April 08, 2015 2:06 PM
To: 'user@drill.apache.org'
Subject: RE: Unable to query data from hdfs
Ramana,
Please
ed dservices.tar file.
>
>
>
> Thanks for your help.
>
>
>
> -Latha
>
>
>
> *From:* Sivasubramaniam, Latha
> *Sent:* Wednesday, April 08, 2015 1:33 PM
>
> *To:* 'user@drill.apache.org'
> *Subject:* RE: Unable to query data from hdfs
>
>
>
subramaniam, Latha
> *Sent:* Wednesday, April 08, 2015 1:33 PM
>
> *To:* 'user@drill.apache.org'
> *Subject:* RE: Unable to query data from hdfs
>
>
>
> Thanks for all the responses.
>
>
>
> Once I renamed files within directories to have extensions .csv, th
Ramana,
Please find attached dservices.tar file.
Thanks for your help.
-Latha
From: Sivasubramaniam, Latha
Sent: Wednesday, April 08, 2015 1:33 PM
To: 'user@drill.apache.org'
Subject: RE: Unable to query data from hdfs
Thanks for all the responses.
Once I renamed files within dire
> 5 rows selected (0.122 seconds)
>
> So far what I have read, impala created parquet file should be like any
> other parquet file, there should not be a problem. If this does not work, I
> need to convert all my tables in text format to parquet format and access
> it with drill. Is
there any utility to do that.
Thanks for all the help.
Latha
From: Sivasubramaniam, Latha
Sent: Wednesday, April 08, 2015 8:00 AM
To: 'user@drill.apache.org'
Subject: RE: Unable to query data from hdfs
Hi,
Thanks for your responses. Even though I had done use hdfs, only when I fully
While I have not had these exact symptoms, I have encountered odd behavior
when hidden directories and hidden files exist that are not in the expected
format. Cleaning off all my Mac hidden folder and ui description files for
example seamed to clean things up for me.
On Wed, Apr 8, 2015 at 10:50 A
Hello,
Firstly, for accessing a specific file, specifying extension is necessary.
You could always create a directory and query the same without extension.
Secondly, when querying a directory, if it contains file with an unknown
extension, Sqlline would fail with file not found.
However, I'm not
Not sure why your extensions in the SP is not working correctly.
It is interesting to see that sometime you can query the test.csv file and
other times not.
What changed between those?
Also _ should not be an issue in the name. And the DIM_Agents is a directory,
so Drill will check the director
Hi,
Thanks for your responses. Even though I had done use hdfs, only when I fully
qualified the file name it worked. But I am not able to access files without
.csv extension.
I modified
"csv": {
"type": "text",
"extensions": [
"csv"
],
"delimiter": ","
To
"csv
Hi Latha,
In your case if you can see the files when you run show files you can just
run
select * from `/test.csv`;
For example:
This is what my workspace looks like:
"userroot": {
"location": "/user/root",
"writable": true,
"defaultInputFormat": null
},
now:
0: jdbc
Hello,
Can you please try the query as follows:
> select * from dfs.root.`/test.csv`;
Or
> use dfs.root;
> select * from `test.csv`;
Regards,
Abhishek
On Tue, Apr 7, 2015 at 3:02 PM, Sivasubramaniam, Latha <
latha.sivasubraman...@aspect.com> wrote:
> Hi,
>
> I have the hdfs storage system reg
I assume the plugin is registered as dfs.
Try
select * from dfs.root.`/test.csv`;
You need to use plugin name and workspace name in the query.
Or you can simple go to the specific schema
use dfs.root;
select * from `/test.csv`;
—Andries
On Apr 7, 2015, at 3:02 PM, Sivasubramaniam, Lat
Hi,
I have the hdfs storage system registered, below is the storage plugin details,
it got registered successfully.
{
"type": "file",
"enabled": true,
"connection": "hdfs://:8020/",
"workspaces": {
"root": {
"location": "/user/root/",
"writable": true,
"defaultInput
15 matches
Mail list logo