date:20161203

Re: Incorrect column name with OVER clause on Drill 1.8

2016-12-03 Thread Abhishek Girish

I ran a similar query on a parquet dataset - and they returned the right
results. This was on Drill 1.9.0 on CentOS. Tried via (1) Sqlline, (2)
Drill web UI and (3) a custom JDBC app. I'm not sure why column aliases
aren't taking affect for you. What client are you using? And also share the
text plan for the query.

> select c_last_review_date as `a`, sum(c_birth_month) over() as `b` from
customer limit 1;
*+--+-+*
*| **   a** | **   b   ** |*
*+--+-+*
*| *2452508 * | *628122
* |**+--+-+*

On Sat, Dec 3, 2016 at 11:16 PM, Rahul Raj 
wrote:

> Ignore the '${}' in the table name ${purchases_by_item_date}, it gets
> substituted as a valid name.
> Rahul
>
> On Sun, Dec 4, 2016 at 12:36 PM, Rahul Raj  com>
> wrote:
>
> > The following query:
> >
> > SELECT
> > bill_date,
> > sum(sell_amt) over() as `cum_purchases_amt`
> > FROM ${purchases_by_item_date}
> >
> > on a parquet file returns column name as '$1' instead of
> cum_purchases_amt.
> > Any ways to override the name?
> >
> > Drill 1.6 also shows the same behaviour.
> >
> > Rahul
> >
> >
>
> --
>  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.
>

Re: Incorrect column name with OVER clause on Drill 1.8

2016-12-03 Thread Rahul Raj

Ignore the '${}' in the table name ${purchases_by_item_date}, it gets
substituted as a valid name.
Rahul

On Sun, Dec 4, 2016 at 12:36 PM, Rahul Raj 
wrote:

> The following query:
>
> SELECT
> bill_date,
> sum(sell_amt) over() as `cum_purchases_amt`
> FROM ${purchases_by_item_date}
>
> on a parquet file returns column name as '$1' instead of cum_purchases_amt.
> Any ways to override the name?
>
> Drill 1.6 also shows the same behaviour.
>
> Rahul
>
>

-- 
 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.

Incorrect column name with OVER clause on Drill 1.8

2016-12-03 Thread Rahul Raj

The following query:

SELECT
bill_date,
sum(sell_amt) over() as `cum_purchases_amt`
FROM ${purchases_by_item_date}

on a parquet file returns column name as '$1' instead of cum_purchases_amt.
Any ways to override the name?

Drill 1.6 also shows the same behaviour.

Rahul

-- 
 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.

Re: Drill 1.9.0 - Embedded mode doesn't work on Windows

2016-12-03 Thread Paul Rogers

Hi Ivy,

Looks like a glitch in the shiny new dynamic UDF feature. Does the directory 
Users/ivy.chan exist on the C: drive? You can work around this in a couple of 
ways.

First, disable the dynamic UDF feature (which is not really needed for an 
embedded Drillbit). Unfortunately, this works only once the Drillbit is up 
because it is a runtime SQL option:

ALTER SESSION SET `exec.udf.enable_dynamic_support` = false

The other is to change the location of the directory that the feature is trying 
to create. Add the following to your $DRILL_HOME/conf/drill-override.conf file:

drill.udf.directory.root: “C:\Temp”

Or any other directory that does, in fact, exist on your system.

Let us know if this works. If not, perhaps Arina (who developed the feature) 
can help provide a better solution.

Thanks,

- Paul


> On Dec 3, 2016, at 6:24 PM,   
> wrote:
> 
> Hi
> 
> I'm trying out 1.9.0 on our Windows server. When launching the embedded mode, 
> I got the following errors:
> 
> 
> E:\software\apache-drill-1.9.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
> DRILL_ARGS - " -u jdbc:drill:zk=local"
> HADOOP_HOME not detected...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Error: Failure in starting embedded Drillbit: 
> org.apache.drill.common.exceptions
> .DrillRuntimeException: Error during udf area creation 
> [/C:/Users/ivy.chan/drill
> /udf/registry] on file system [file:///] (state=,code=0)
> java.sql.SQLException: Failure in starting embedded Drillbit: 
> org.apache.drill.c
> ommon.exceptions.DrillRuntimeException: Error during udf area creation 
> [/C:/User
> s/ivy.chan/drill/udf/registry] on file system [file:///]
>at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnection
> Impl.java:128)
>at 
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
> lJdbc41Factory.java:70)
>at 
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
> va:69)
>at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDri
> ver.java:143)
>at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
>at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> 
>at sqlline.Commands.connect(Commands.java:1083)
>at sqlline.Commands.connect(Commands.java:1015)
>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:62)
>at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
>at java.lang.reflect.Method.invoke(Method.java:497)
>at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.jav
> a:36)
>at sqlline.SqlLine.dispatch(SqlLine.java:742)
>at sqlline.SqlLine.initArgs(SqlLine.java:528)
>at sqlline.SqlLine.begin(SqlLine.java:596)
>at sqlline.SqlLine.start(SqlLine.java:375)
>at sqlline.SqlLine.main(SqlLine.java:268)
> Caused by: org.apache.drill.common.exceptions.DrillRuntimeException: Error 
> durin
> g udf area creation [/C:/Users/ivy.chan/drill/udf/registry] on file system 
> [file
> :///]
>at 
> org.apache.drill.common.exceptions.DrillRuntimeException.format(Drill
> RuntimeException.java:49)
>at 
> org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.createA
> rea(RemoteFunctionRegistry.java:246)
>at 
> org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.prepare
> Areas(RemoteFunctionRegistry.java:208)
>at 
> org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.init(Re
> moteFunctionRegistry.java:106)
>at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:126)
>at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnection
> Impl.java:119)
>... 18 more
> Caused by: java.lang.IllegalStateException: Area 
> [/C:/Users/ivy.chan/drill/udf/r
> egistry] must be writable and executable for application user
>at 
> com.google.common.base.Preconditions.checkState(Preconditions.java:19
> 7)
>at 
> org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.createA
> rea(RemoteFunctionRegistry.java:238)
>... 22 more
> apache drill 1.9.0
> "got drill?"
> 
> It is working on 1.8.0.
> 
> I also got compile error on sqlline.log:
> 
> 2016-12-03 21:05:59,026 [main] WARN  o.a.drill.exec.util.GuavaPatcher - 
> Unable to patch Guava classes.
> javassist.CannotCompileException: by java.lang.LinkageError: loader (instance 
> of  sun/misc/Launcher$AppClassLoader): attempted  duplicate class definition 
> for name: "com/google/common/base/Stopwatch"
>at javassist.ClassPool.toClass(ClassPool.java:1085) 
> ~[javassist-3.12.1.GA.jar:na]
>at javassist.ClassPool.toClass(ClassPool.java:1028) 
>

Re: Drill 1.9.0 - Embedded mode doesn't work on Windows

2016-12-03 Thread Abhishek Girish

Can you confirm that the location has the right permissions? May be
explicitly provide permissions for the folder 'drill' in your home dir?

On Sat, Dec 3, 2016 at 6:24 PM,  wrote:

> Caused by: java.lang.IllegalStateException: Area
> [/C:/Users/ivy.chan/drill/udf/r
> egistry] must be writable and executable for application user
>

Drill 1.9.0 - Embedded mode doesn't work on Windows

2016-12-03 Thread IChan

Hi

I'm trying out 1.9.0 on our Windows server. When launching the embedded mode, I 
got the following errors:


E:\software\apache-drill-1.9.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Failure in starting embedded Drillbit: org.apache.drill.common.exceptions
.DrillRuntimeException: Error during udf area creation [/C:/Users/ivy.chan/drill
/udf/registry] on file system [file:///] (state=,code=0)
java.sql.SQLException: Failure in starting embedded Drillbit: org.apache.drill.c
ommon.exceptions.DrillRuntimeException: Error during udf area creation [/C:/User
s/ivy.chan/drill/udf/registry] on file system [file:///]
at org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnection
Impl.java:128)
at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
lJdbc41Factory.java:70)
at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
va:69)
at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDri
ver.java:143)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)

at sqlline.Commands.connect(Commands.java:1083)
at sqlline.Commands.connect(Commands.java:1015)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.jav
a:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.initArgs(SqlLine.java:528)
at sqlline.SqlLine.begin(SqlLine.java:596)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.common.exceptions.DrillRuntimeException: Error durin
g udf area creation [/C:/Users/ivy.chan/drill/udf/registry] on file system [file
:///]
at org.apache.drill.common.exceptions.DrillRuntimeException.format(Drill
RuntimeException.java:49)
at org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.createA
rea(RemoteFunctionRegistry.java:246)
at org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.prepare
Areas(RemoteFunctionRegistry.java:208)
at org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.init(Re
moteFunctionRegistry.java:106)
at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:126)
at org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnection
Impl.java:119)
... 18 more
Caused by: java.lang.IllegalStateException: Area [/C:/Users/ivy.chan/drill/udf/r
egistry] must be writable and executable for application user
at com.google.common.base.Preconditions.checkState(Preconditions.java:19
7)
at org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.createA
rea(RemoteFunctionRegistry.java:238)
... 22 more
apache drill 1.9.0
"got drill?"

It is working on 1.8.0.

I also got compile error on sqlline.log:

2016-12-03 21:05:59,026 [main] WARN  o.a.drill.exec.util.GuavaPatcher - Unable 
to patch Guava classes.
javassist.CannotCompileException: by java.lang.LinkageError: loader (instance 
of  sun/misc/Launcher$AppClassLoader): attempted  duplicate class definition 
for name: "com/google/common/base/Stopwatch"
at javassist.ClassPool.toClass(ClassPool.java:1085) 
~[javassist-3.12.1.GA.jar:na]
at javassist.ClassPool.toClass(ClassPool.java:1028) 
~[javassist-3.12.1.GA.jar:na]
at javassist.ClassPool.toClass(ClassPool.java:986) 
~[javassist-3.12.1.GA.jar:na]
at javassist.CtClass.toClass(CtClass.java:1079) 
~[javassist-3.12.1.GA.jar:na]
at 
org.apache.drill.exec.util.GuavaPatcher.patchStopwatch(GuavaPatcher.java:66) 
~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.util.GuavaPatcher.patch(GuavaPatcher.java:36) 
~[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.exec.server.Drillbit.(Drillbit.java:63) 
[drill-java-exec-1.9.0.jar:1.9.0]
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:118)
 [drill-jdbc-1.9.0.jar:1.9.0]
at 
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:70)
 [drill-jdbc-1.9.0.jar:1.9.0]
at 
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69) 
[drill-jdbc-1.9.0.jar:1.9.0]
at 
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)

Re: Last Column showing blank in csv file

2016-12-03 Thread Abhishek Girish

Thanks Khurram, this was the attribute I thought din't exist as I couldn't
find it anywhere our docs.

This can also be added to format config:

"csv": {
  "type": "text",
  "extensions": [
"csv"
  ],
  "lineDelimiter": "\r\n",
  "extractHeader": true,
  "delimiter": ","
}

Tried with 1.9.0 on Windows (using the above format config) and the queries
work as expected.

We should update [1] with this information.

[1] https://drill.apache.org/docs/plugin-configuration-basic
s/#list-of-attributes-and-definitions

P.S. So there is no need to file a new JIRA for this.

On Sat, Dec 3, 2016 at 4:12 AM, Khurram Faraaz  wrote:

> I am not exactly sure this will work (I haven't tried it on Windows 10)
> Setting lineDelimiter to '\r\n' should try to help in your case, can you
> please try. For details look at DRILL-3149
> 
>
> Example:
>
> select * from table(dfs.`my_table`(type=>'text', 'lineDelimiter'=>'\r\n'))
>
>
> On Sat, Dec 3, 2016 at 2:28 AM, Kunal Khatua  wrote:
>
> > There is a dos2unix utility for Linux that allows you to substitute the
> > multichar newline with the single char newline.
> >
> > For Windows, you can use either a similar util on SourceForge or the
> > CygUtils (part of the Cygwin shell, I believe) to achieve the same
> > conversion.
> >
> > In the meanwhile, like Abhishek suggested, please file a JIRA for this so
> > that the issue can be tracked and fixed in a future release.
> >
> > Thanks
> > Kunal
> >
> > On Wed 30-Nov-2016 8:24:00 PM, Abhishek Girish <
> abhishek.gir...@gmail.com>
> > wrote:
> > Well the only workaround I got to work is this: I saved the file in
> > UNIX/OS_X Format and executed the query successfully (with no blanks in
> the
> > class column).
> >
> > Some text editors such as Notepad++ let you do this directly on Windows.
> Or
> > you could use a utility like iconv or dos2unix for larger files like Leon
> > suggested.
> >
> > Also, please file an enhancement JIRA for supporting a new 'newline'
> > attribute (which takes multi-byte values) for text formats. This will be
> > helpful for files on windows which use CRLF (\r\n) as newline characters.
> >
> > On Wed, Nov 30, 2016 at 7:56 PM, Abhishek Girish
> > wrote:
> >
> > > Okay, I could reproduce the issue on Windows.
> > >
> > > 0: jdbc:drill:zk=local> select A.sepalen, A.sepalwidth, A.patelen,
> > > A.patelwidth,
> > > A.class from dfs.`/drill/tmp.csv` as A;
> > > +--+-+--+--++
> > > | sepalen | sepalwidth | patelen | patelwidth | class |
> > > +--+-+--+--++
> > > | 5.1 | 3.5 | 1.4 | Iris-setosa | |
> > > | 4.9 | 3 | 1.4 | Iris-setosa | |
> > > | 4.7 | 3.2 | 1.3 | Iris-setosa | |
> > > | 4.6 | 3.1 | 1.5 | Iris-setosa | |
> > > | 5 | 3.6 | 1.4 | Iris-setosa | |
> > > | 5.4 | 3.9 | 1.7 | Iris-setosa | |
> > > | 4.6 | 3.4 | 1.4 | Iris-setosa | |
> > > | 5 | 3.4 | 1.5 | Iris-setosa | |
> > > | 4.4 | 2.9 | 1.4 | Iris-setosa | |
> > > | 4.9 | 3.1 | 1.5 | Iris-setosa | |
> > > | 5.4 | 3.7 | 1.5 | Iris-setosa | |
> > > | 4.8 | 3.4 | 1.6 | Iris-setosa | |
> > > +--+-+--+--++
> > > 12 rows selected (0.277 seconds)
> > >
> > > I'll get back if and once I have a workaround / solution.
> > >
> > > On Wed, Nov 30, 2016 at 7:36 PM, Abhishek Girish
> > > abhishek.gir...@gmail.com> wrote:
> > >
> > >> I forgot to mention that, the other query works too.
> > >>
> > >> > select A.sepalen, A.sepalwidth, A.patelen, A.patelwidth, A.class
> from
> > >> dfs.tmp.`tmp.csv` as A;
> > >> +--+-+--+--++
> > >> | sepalen | sepalwidth | patelen | patelwidth | class |
> > >> +--+-+--+--++
> > >> | 5.1 | 3.5 | 1.4 | Iris-setosa | 0.2 |
> > >> | 4.9 | 3 | 1.4 | Iris-setosa | 0.2 |
> > >> | 4.7 | 3.2 | 1.3 | Iris-setosa | 0.2 |
> > >> | 4.6 | 3.1 | 1.5 | Iris-setosa | 0.2 |
> > >> | 5 | 3.6 | 1.4 | Iris-setosa | 0.2 |
> > >> | 5.4 | 3.9 | 1.7 | Iris-setosa | 0.4 |
> > >> | 4.6 | 3.4 | 1.4 | Iris-setosa | 0.3 |
> > >> | 5 | 3.4 | 1.5 | Iris-setosa | 0.2 |
> > >> | 4.4 | 2.9 | 1.4 | Iris-setosa | 0.2 |
> > >> | 4.9 | 3.1 | 1.5 | Iris-setosa | 0.1 |
> > >> | 5.4 | 3.7 | 1.5 | Iris-setosa | 0.2 |
> > >> | 4.8 | 3.4 | 1.6 | Iris-setosa | 0.2 |
> > >> +--+-+--+--++
> > >> 12 rows selected (0.31 seconds)
> > >>
> > >>
> > >> On Wed, Nov 30, 2016 at 8:15 AM, Leon Clayton
> > >> wrote:
> > >>
> > >>> Are we sure there is no hidden characters on the end of the one or
> more
> > >>> lines. thinking ?
> > >>>
> > >>> try a dos2unix on the file to check this theory out.
> > >>>
> > >>>
> > >>> > On 30 Nov 2016, at 10:45, Sanjiv Kumar wrote:
> > >>> >
> > >>> > Hello
> > >>> > Yes you are right. select * from `tmp.csv`
> > >>> > Is Working fine, but if

Re: Last Column showing blank in csv file

2016-12-03 Thread Khurram Faraaz

I am not exactly sure this will work (I haven't tried it on Windows 10)
Setting lineDelimiter to '\r\n' should try to help in your case, can you
please try. For details look at DRILL-3149


Example:

select * from table(dfs.`my_table`(type=>'text', 'lineDelimiter'=>'\r\n'))


On Sat, Dec 3, 2016 at 2:28 AM, Kunal Khatua  wrote:

> There is a dos2unix utility for Linux that allows you to substitute the
> multichar newline with the single char newline.
>
> For Windows, you can use either a similar util on SourceForge or the
> CygUtils (part of the Cygwin shell, I believe) to achieve the same
> conversion.
>
> In the meanwhile, like Abhishek suggested, please file a JIRA for this so
> that the issue can be tracked and fixed in a future release.
>
> Thanks
> Kunal
>
> On Wed 30-Nov-2016 8:24:00 PM, Abhishek Girish 
> wrote:
> Well the only workaround I got to work is this: I saved the file in
> UNIX/OS_X Format and executed the query successfully (with no blanks in the
> class column).
>
> Some text editors such as Notepad++ let you do this directly on Windows. Or
> you could use a utility like iconv or dos2unix for larger files like Leon
> suggested.
>
> Also, please file an enhancement JIRA for supporting a new 'newline'
> attribute (which takes multi-byte values) for text formats. This will be
> helpful for files on windows which use CRLF (\r\n) as newline characters.
>
> On Wed, Nov 30, 2016 at 7:56 PM, Abhishek Girish
> wrote:
>
> > Okay, I could reproduce the issue on Windows.
> >
> > 0: jdbc:drill:zk=local> select A.sepalen, A.sepalwidth, A.patelen,
> > A.patelwidth,
> > A.class from dfs.`/drill/tmp.csv` as A;
> > +--+-+--+--++
> > | sepalen | sepalwidth | patelen | patelwidth | class |
> > +--+-+--+--++
> > | 5.1 | 3.5 | 1.4 | Iris-setosa | |
> > | 4.9 | 3 | 1.4 | Iris-setosa | |
> > | 4.7 | 3.2 | 1.3 | Iris-setosa | |
> > | 4.6 | 3.1 | 1.5 | Iris-setosa | |
> > | 5 | 3.6 | 1.4 | Iris-setosa | |
> > | 5.4 | 3.9 | 1.7 | Iris-setosa | |
> > | 4.6 | 3.4 | 1.4 | Iris-setosa | |
> > | 5 | 3.4 | 1.5 | Iris-setosa | |
> > | 4.4 | 2.9 | 1.4 | Iris-setosa | |
> > | 4.9 | 3.1 | 1.5 | Iris-setosa | |
> > | 5.4 | 3.7 | 1.5 | Iris-setosa | |
> > | 4.8 | 3.4 | 1.6 | Iris-setosa | |
> > +--+-+--+--++
> > 12 rows selected (0.277 seconds)
> >
> > I'll get back if and once I have a workaround / solution.
> >
> > On Wed, Nov 30, 2016 at 7:36 PM, Abhishek Girish
> > abhishek.gir...@gmail.com> wrote:
> >
> >> I forgot to mention that, the other query works too.
> >>
> >> > select A.sepalen, A.sepalwidth, A.patelen, A.patelwidth, A.class from
> >> dfs.tmp.`tmp.csv` as A;
> >> +--+-+--+--++
> >> | sepalen | sepalwidth | patelen | patelwidth | class |
> >> +--+-+--+--++
> >> | 5.1 | 3.5 | 1.4 | Iris-setosa | 0.2 |
> >> | 4.9 | 3 | 1.4 | Iris-setosa | 0.2 |
> >> | 4.7 | 3.2 | 1.3 | Iris-setosa | 0.2 |
> >> | 4.6 | 3.1 | 1.5 | Iris-setosa | 0.2 |
> >> | 5 | 3.6 | 1.4 | Iris-setosa | 0.2 |
> >> | 5.4 | 3.9 | 1.7 | Iris-setosa | 0.4 |
> >> | 4.6 | 3.4 | 1.4 | Iris-setosa | 0.3 |
> >> | 5 | 3.4 | 1.5 | Iris-setosa | 0.2 |
> >> | 4.4 | 2.9 | 1.4 | Iris-setosa | 0.2 |
> >> | 4.9 | 3.1 | 1.5 | Iris-setosa | 0.1 |
> >> | 5.4 | 3.7 | 1.5 | Iris-setosa | 0.2 |
> >> | 4.8 | 3.4 | 1.6 | Iris-setosa | 0.2 |
> >> +--+-+--+--++
> >> 12 rows selected (0.31 seconds)
> >>
> >>
> >> On Wed, Nov 30, 2016 at 8:15 AM, Leon Clayton
> >> wrote:
> >>
> >>> Are we sure there is no hidden characters on the end of the one or more
> >>> lines. thinking ?
> >>>
> >>> try a dos2unix on the file to check this theory out.
> >>>
> >>>
> >>> > On 30 Nov 2016, at 10:45, Sanjiv Kumar wrote:
> >>> >
> >>> > Hello
> >>> > Yes you are right. select * from `tmp.csv`
> >>> > Is Working fine, but if select column then the last column data
> showing
> >>> > blank.
> >>> > Run this query:-
> >>> > select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`,
> >>> A.class
> >>> > from dfs.tmp.`copydata.csv` as A;
> >>> >
> >>> > If you run this query you will get last column data as blank.
> >>> >
> >>> > On Wed, Nov 30, 2016 at 11:15 AM, Sanjiv Kumar
> >>> wrote:
> >>> >
> >>> >> I am using latest version 1.8 and in window 10 operating system.
> >>> >>
> >>> >> On Tue, Nov 29, 2016 at 11:40 AM, Sanjiv Kumar
> >>> >> wrote:
> >>> >>
> >>> >>> I already pasted the csv file. Just copy and save it as csv. I am
> >>> also
> >>> >>> attaching csv file. And the query is same as i mention above.
> >>> >>>
> >>> >>> select A.`sepalen`, A.`sepalwidth`, A.`patelen`, A.`patelwidth`,
> >>> A.class
> >>> >>> from dfs.tmp.`copydata.csv` as A;
> >>> >>>
> >>> >>> On Mon, Nov 28, 2016 at 6:30 PM, Sanjiv

Re: Incorrect column name with OVER clause on Drill 1.8

Re: Incorrect column name with OVER clause on Drill 1.8

Incorrect column name with OVER clause on Drill 1.8

Re: Drill 1.9.0 - Embedded mode doesn't work on Windows

Re: Drill 1.9.0 - Embedded mode doesn't work on Windows

Drill 1.9.0 - Embedded mode doesn't work on Windows

Re: Last Column showing blank in csv file

Re: Last Column showing blank in csv file

8 matches

Site Navigation

Mail list logo

Footer information