Re: Date Formatting Question

Thank you to everyone for your help. I have to admit, that is probably the most non-intuitive function name to accomplish this task. ;-) — C > On Sep 8, 2016, at 18:17, Andries Engelbrecht > wrote: > > And I meant to use MM not mm :-( > > 0: jdbc:drill:> select

Re: Date Formatting Question

Looks like Jason just beat me to it :-) > On Sep 8, 2016, at 3:15 PM, Andries Engelbrecht > wrote: > > You are likely looking for the to_char function to convert date to a > different string format. You can always convert back to a date by using > to_date. > >

Re: Date Formatting Question

You are likely looking for the to_char function to convert date to a different string format. You can always convert back to a date by using to_date. select current_date, to_char(current_date,'mm/dd/') from (values(1)); +---+-+ | current_date | EXPR$1|

Re: cannot start up drill on Windows 2012R2

Not sure about redistributing with Drill but the user guide should definitely mention it as a required step for running on Windows 2012R2. Could you please create a JIRA to update the Drill documentation. aditya... On Thu, Sep 8, 2016 at 11:29 AM, Holy Alexander < alexander.h...@derstandard.at>

Re: Drill Performance

late reply... We are trying to run drill on 200 nodes, but we keep getting random lost of connectivity with certain nodes, which spoil the query completely, happens maybe 50% of the time. It depends on how many files gets queried, basically how heavy is the query. It looks exactly like this

Re: Date Formatting Question

Hi Khurram, I looked through all that already and I didn't see anything that did what I was wanting to do, or am I missing it? Thanks, -- C On Thu, Sep 8, 2016 at 3:14 PM, Khurram Faraaz wrote: > Here is the link to currently supported datetime functions in Drill > >

Re: Date Formatting Question

Here is the link to currently supported datetime functions in Drill https://drill.apache.org/docs/date-time-functions-and-arithmetic/#extract On Fri, Sep 9, 2016 at 12:32 AM, Charles Givre wrote: > Hello everyone, > I have a question about formatting dates. Let's say that I

RE: cannot start up drill on Windows 2012R2

Bingo! MSVCR100.dll (a very old C/C++ runtime DLL) is missing. This should be distributed/installed along with winutils Thanks a lot! Best regards, Alexander -Original Message- From: Aditya [mailto:adityakish...@gmail.com] Sent: 08 September 2016 19:46 To: user

Queries over Swift?

The Drill FAQ mentions that Swift can be queried as well as S3. I have found an S3 plugin (https://drill.apache.org/docs/s3-storage-plugin/) but nothing yet for docs, examples, or plugins for Swift. Is there any documentation available?

Re: cannot start up drill on Windows 2012R2

One reason I can think of is that "%HADOOP_HOME%" is not set to point to "%DRILL_HOME%\winutils" or a valid Hadoop home directory. If it is not the case, please check if you are able to run "d:\apache-drill\winutils\bin\winutils.exe" in a command prompt without any error. On Thu, Sep 8, 2016 at

cannot start up drill on Windows 2012R2

Today I tried installing Drill 1.8 (in embedded mode) on a production Windows 2012R2 Server, using the identical setup that is working find on my Windows 10 Development workstation. Disk layout is identical on the production machine. For reasons I can't figure, drill fails to write to