Re: Incorrect column name with OVER clause on Drill 1.8

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

Re: Incorrect column name with OVER clause on Drill 1.8

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

Incorrect column name with OVER clause on Drill 1.8

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

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

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

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

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 >

Drill 1.9.0 - Embedded mode doesn't work on Windows

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

Re: Last Column showing blank in csv file

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,

Re: Last Column showing blank in csv file

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',