You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sanjiv Kumar <kt...@gmail.com> on 2017/01/31 15:12:27 UTC
Extra Column are showing in output while querying files
Hello I am using Drill latest version (1.9) in window and in embedded mode.
I have csv file in my local drive (D://). While querying through csv file
some extra columns are showing in output.
EXAMPLE:-
Query:- select * from dfs.`D:\Test1.csv`;
Output:- Result is showing file but some extra column are also showing
like fqn, filename,filepath, suffix columns are showing.
Please tell me how to restrict those extra column.?
*Thanks & Regards,*
*Sanjiv Kumar*
-
Re: Extra Column are showing in output while querying files
Posted by Sanjiv Kumar <kt...@gmail.com>.
Yes I have a jdbc plugin enabled.
On Tue, Jan 31, 2017 at 8:42 PM, Sanjiv Kumar <kt...@gmail.com> wrote:
> Hello I am using Drill latest version (1.9) in window and in embedded mode.
>
> I have csv file in my local drive (D://). While querying through csv file
> some extra columns are showing in output.
>
> EXAMPLE:-
>
> Query:- select * from dfs.`D:\Test1.csv`;
>
> Output:- Result is showing file but some extra column are also showing
> like fqn, filename,filepath, suffix columns are showing.
>
> Please tell me how to restrict those extra column.?
>
>
>
>
>
> *Thanks & Regards,*
> *Sanjiv Kumar*
>
> -
>
>
>
--
*Thanks & Regards,*
*Sanjiv Kumar*
-
*Mob.No: +917411211960*
Re: Extra Column are showing in output while querying files
Posted by Rahul Raj <ra...@option3consulting.com>.
Do you have a jdbc plugin enabled? https://issues.apache.org/
jira/browse/DRILL-4903
Rahul
On Jan 31, 2017 20:42, "Sanjiv Kumar" <kt...@gmail.com> wrote:
> Hello I am using Drill latest version (1.9) in window and in embedded mode.
>
> I have csv file in my local drive (D://). While querying through csv file
> some extra columns are showing in output.
>
> EXAMPLE:-
>
> Query:- select * from dfs.`D:\Test1.csv`;
>
> Output:- Result is showing file but some extra column are also showing
> like fqn, filename,filepath, suffix columns are showing.
>
> Please tell me how to restrict those extra column.?
>
>
>
>
>
> *Thanks & Regards,*
> *Sanjiv Kumar*
>
> -
>
--
**** This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.****