Re: Drill 0.9 slowness/hanging

2015-05-11 Thread Ramana Inukonda
We have fixed the web UI slowness in an upcoming release. But if you have multiple drillbits try other nodes in the cluster for the web UI. I have observed that sometimes the other nodes have better luck. Regards Ramana On Mon, May 11, 2015 at 5:07 PM, Minnow Noir wrote: > Hanifi: The web UI

Re: Stopping Drillbit and preventing it from restarting automatically on MapR sandbox

2015-04-29 Thread Ramana Inukonda
Run configure.sh -R on all nodes. On Wednesday, April 29, 2015, Alexander Zarei wrote: > Thanks a lot Chun. I just tried it on my freshly downloaded MapR sandbox > and it give me the following error: > > [root@maprdemo ~]# maprcli node services -name Drill -action stop -nodes > maprdemo > ERROR

Re: SQL Comments

2015-04-28 Thread Ramana Inukonda
Sorry, Scratch that. Somehow had a notion that worked. Does not seem to be the case. Regards Ramana On Tue, Apr 28, 2015 at 11:25 AM, Ramana Inukonda wrote: > You can use -- > > Example: > -- using 1395599672 as a seed to the RNG select l_returnflag, l_linestatus, > sum

Re: SQL Comments

2015-04-28 Thread Ramana Inukonda
You can use -- Example: -- using 1395599672 as a seed to the RNG select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice * (1 - l_discount)) as sum_disc_price, sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, av

Re: Unable to query data from hdfs

2015-04-08 Thread Ramana Inukonda
Hey Latha, Would it be possible for you to share a sample file generated from impala which you cannot read? I am testing these out and it will be great to see what is not working. If the data is sensitive if you can share impala metadata that would be enormously helpful as well. Regards Ramana

Re: Unable to query data from hdfs

2015-04-07 Thread Ramana Inukonda
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