Re: IndexR, a new storage plugin for Drill

2017-01-03 Thread WeiWan
Hi, It will take some time for IndexR plugin to merge into Drill. But you can try it out already by following those documents. Compilation: https://github.com/shunfei/indexr/wiki/Compilation Deployment: https://github.com/shunfei/indexr/wik

Re: while running long query drill stopped

2017-01-03 Thread Paul Rogers
Hi Sanjiv, Drill should have written a log file. Does the log file contain an entry for the exception? Perhaps post the first five or so lines from that log entry (the whole stack trace can be pretty long.) Was this a fatal exception from Drill or did the JVM itself die? (If the JVM dies, it o

while running long query drill stopped

2017-01-03 Thread Sanjiv Kumar
Hello I am using drill latest version (1.9) in embedded mode in Ubuntu system. My query is :- If i run query having less number of records, drill working fine. But If i run long query having (8124042 records), drill stopped without throwing any error. NOTE:-

Re:How to use apache drill using rest api when authentication and HTTPS are enabled

2017-01-03 Thread Anand AV
Just use Query https://MYDRILLHOST:8047/j_security_check?j_username=USERNAME&j_password=PASSWORD You will get a cookie of JSESSIONID. Use that cookie for future request. Best regards, Anand.AV

Re: IndexR, a new storage plugin for Drill

2017-01-03 Thread Jinfeng Ni
Forward to drill dev list. People on dev list might be interested in this as well. On Tue, Jan 3, 2017 at 8:22 AM, Jinfeng Ni wrote: > Looks like IndexR is very interesting storage plugin. Although I have > not looked into the detail, I'm looking forward to seeing the PR and > hopefully getting

Re: IndexR, a new storage plugin for Drill

2017-01-03 Thread Jinfeng Ni
Looks like IndexR is very interesting storage plugin. Although I have not looked into the detail, I'm looking forward to seeing the PR and hopefully getting this into Drill! Thanks, Jinfeng On Tue, Jan 3, 2017 at 7:30 AM, WeiWan wrote: > Hi Charles, > > It would be great if IndexR plugin can b

Re: a drill question

2017-01-03 Thread WeiWan
'ISO-8859-1?? character set does not support Chinese characters. Put -Dsaffron.default.charset=UTF-16LE to your DRILL_JAVA_OPTS, i.e. export DRILL_JAVA_OPTS="-Dsaffron.default.charset=UTF-16LE ... " in drill-env.sh. And after you change the character set setting, another exception may throw, ch

Re: IndexR, a new storage plugin for Drill

2017-01-03 Thread WeiWan
Hi Charles, It would be great if IndexR plugin can be merged into official Drill project. I will do some more tests based on latest Drill version and submit a PR. Regards Flow Wei > On Jan 3, 2017, at 23:18, Charles Givre wrote: > > This sounds really interesting. Will you be submitting a

Re: IndexR, a new storage plugin for Drill

2017-01-03 Thread Charles Givre
This sounds really interesting. Will you be submitting a PR to integrate this into the main Drill codebase? — C > On Jan 3, 2017, at 03:35, WeiWan wrote: > > IndexR is a distributed, columnar storage system based on HDFS, which focus > on fast analyse, both for massive static(historical) data

Re: IndexR, a new storage plugin for Drill

2017-01-03 Thread John Omernik
This looks very interesting! Can't wait to see some how-to's to get the the server nodes setup, and kafka pipelines setup. I'd be very interested in trying this once it's setup. Thanks! On Tue, Jan 3, 2017 at 2:35 AM, WeiWan wrote: > IndexR is a distributed, columnar storage system based on

a drill question

2017-01-03 Thread roller
hello ,i have a drill `s question.when i excute this sql "select ID , Code , id as newId, case when Code='auth' then '??' else 'ttt' end as newCode from ( select ID,Name,Code from mysql.auth_center.admin_menu where 1=1 ) as sqlInput ", it produce a exception,ths erro info is "org.apache.drill

IndexR, a new storage plugin for Drill

2017-01-03 Thread WeiWan
IndexR is a distributed, columnar storage system based on HDFS, which focus on fast analyse, both for massive static(historical) data and rapidly ingesting realtime data. IndexR is designed for OLAP. Fast analyze on large dataset Realtime ingestion with zero delay for query Deep integration with

How to use apache drill using rest api when authentication and HTTPS are enabled

2017-01-03 Thread Sanjiv Kumar
Hello Wish you a happy new year. I have a doubt.. How to access Apache Drill using REST API when authentication and https both are enabled? -- --- Thanks & Regards Sanjiv Kumar