Re: Drill on Azure

That's great! Thanks Neeraja. On Tue, Aug 2, 2016 at 6:18 PM, Neeraja Rentachintala < nrentachint...@maprtech.com> wrote: > Just happened to see this great set of comprehensive blog/tutorials on how > to deploy Drill on Azure and use it with a variety of sources on Azure. > Wanted to share the li

Re: coaxing hour of day from a timestamp

Thanks, everybody. I think I got it working now. Confusion arose from being able to treat the string as though it were already a timestamp without having transformed it. On Tue, Aug 2, 2016 at 5:25 PM, Andries Engelbrecht < aengelbre...@maprtech.com> wrote: > To simplify Vince's query > > 0: jdbc

Re: coaxing hour of day from a timestamp

To simplify Vince's query 0: jdbc:drill:> select date_part('hour', to_timestamp('28/04/16 2:00', 'dd/MM/yy HH:mm')) from (values(1)); +-+ | EXPR$0 | +-+ | 2 | +-+ But basically to_timestamp allows you to specify the format. --Andries > On Aug 2, 2016, at 5:14 PM

Re: coaxing hour of day from a timestamp

How about this? 0: jdbc:drill:> select date_part('hour', t.ts) from (select to_timestamp('28/04/16 2:00', 'dd/MM/yy HH:mm') ts from sys.version) t; +-+ | EXPR$0 | +-+ | 2 | +-+ 1 row selected (0.442 seconds) Vince Gonzalez Systems Engineer 212.694.3879 m

Drill on Azure

Just happened to see this great set of comprehensive blog/tutorials on how to deploy Drill on Azure and use it with a variety of sources on Azure. Wanted to share the link with the other users that might be interested in this topic. https://blogs.msdn.microsoft.com/data_otaku/2016/05/27/deploying-

Re: Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 22: Table 'students' not found

If I have followed your steps correctly, I see that you have not switched to "hbase" schema before running query against an HBase table. Please use one of the following methods. 0: jdbc:drill:zk=local> use hbase; 0: jdbc:drill:zk=local> select * from students; or 0: jdbc:drill:zk=local> select

Re: Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 22: Table 'students' not found

I'll take a look and get back to you soon. On Tue, Aug 2, 2016 at 1:03 AM, Stack wrote: > I was trying 1.7.0 against the tip of the hbase 1.1 branch and I was > getting: > > 0: jdbc:drill:zk=local> select * from students; > Error: SYSTEM ERROR: IllegalAccessError: tried to access method > com.go

Re: coaxing hour of day from a timestamp

*Query:* select Datatime_start, date_part('day',Datatime_Start) `day`, date_part('month',Datatime_Start) `month`, date_part('year',Datatime_Start) `year`, date_part('hour',Datatime_Start) `hour`, date_part('minute',Datatime_Start) `minute` from dfs.tmp.tv limit 1 The question is = how do I get hou

Connecting Drill to WebHdfs

Hi all, Does the Drill support connect to WebHdfs? Could you share the storage config if this is supported? Thanks Kumiko

Re: coaxing hour of day from a timestamp

Attachments do not show on the mail list, perhaps just type out an example. --Andries > On Aug 2, 2016, at 1:56 PM, Joseph Blue wrote: > > My bad on the formatting. Here is a screen shot of the query. Note bad m/d/y > and hour=min=sec=0.0 > > > On Tue, Aug 2, 2016 at 1:46 PM, Joseph Blue

Re: coaxing hour of day from a timestamp

My bad on the formatting. Here is a screen shot of the query. Note bad m/d/y and hour=min=sec=0.0 [image: Inline image 1] On Tue, Aug 2, 2016 at 1:46 PM, Joseph Blue wrote: > The field I have is a timestamp. The date is obviously in wrong order in > the time stamp (I can break it up and reassemb

coaxing hour of day from a timestamp

The field I have is a timestamp. The date is obviously in wrong order in the time stamp (I can break it up and reassemble to get a good date, so no problem there). I do not seem to be able to get the hour of the day using the date_parts, so that data seems obscured. Any ideas how to get the 2 o'clo

Re: Drill CPU Usage

On Tue, Aug 2, 2016 at 12:49 AM, Avi Haleva wrote: > Hi, > I'm in the process of evaluating Drill as a analytic repositiory. > I've noticed that even when idle, the drillbit process consume 20% of a > single core constantly. > > Is that expected behavior or have I miss configured something. > I

Drill CPU Usage

Hi, I'm in the process of evaluating Drill as a analytic repositiory. I've noticed that even when idle, the drillbit process consume 20% of a single core constantly. Is that expected behavior or have I miss configured something. I'm running drill in single node with zookeeper in a non-embeded mo

Re: concurrent get connection in different node

nevermind , I changed to jdbc:drill:drillbit=node1;schema=hbase and its work now. 2016-08-02 20:04 GMT+08:00 qiang li : > Sorry , I follow the doc use the url : > > jdbc:drill:drillbit=node1/drill/drillbits2;schema=hbase > > It's throw java.nio.channels.UnresolvedAddressException. But the host

Re: concurrent get connection in different node

Sorry , I follow the doc use the url : jdbc:drill:drillbit=node1/drill/drillbits2;schema=hbase It's throw java.nio.channels.UnresolvedAddressException. But the host name is configured in the hosts file. Did I miss something? Thanks 2016-08-02 17:45 GMT+08:00 qiang li : > Great, that's what

Re: concurrent get connection in different node

Great, that's what I need. I missed the detail in the doc. Thanks 2016-08-02 0:01 GMT+08:00 Dechang Gu : > You may try to connect to a different drillbit in, say, a round-robin > fashion, for the > queries. See reference: > > https://drill.apache.org/docs/using-the-jdbc-driver/#using-the-jdbc-u

Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 22: Table 'students' not found

I was trying 1.7.0 against the tip of the hbase 1.1 branch and I was getting: 0: jdbc:drill:zk=local> select * from students; Error: SYSTEM ERROR: IllegalAccessError: tried to access method com.google.common.base.Stopwatch.()V from class org.apache.hadoop.hbase.zookeeper.MetaTableLocator [Error

Drill CPU Usage

Hi, I'm in the process of evaluating Drill as a analytic repositiory. I've noticed that even when idle, the drillbit process consume 20% of a single core constantly. Is that expected behavior or have I miss configured something. I'm running drill in single node with zookeeper in a non-embeded mo