The following query run through Drill Explorer/ODBC returns NULL, while running
it from SQLLINE it works fine.
select from_unixtime(1432912733) from `sys`.`version`;
Is this a limitation of the ODBC driver?
Running on Drill 1.0.0 on Windows in Embedded mode. Using 1.0.0 ODBC driver
Yeah, I'm looking at the avoiding the BSON JSON steps.
On Tue, Jun 9, 2015 at 12:17 AM, Adam Gilmore dragoncu...@gmail.com wrote:
We haven't quite hit it with that much data in Mongo. We're compressing
Mongo data to Parquet in smaller chunks so we never query Mongo with that
much.
We've
Hi,
I have installed Apache Drill on my local windows workstation.
How do I install Storage Plugin for distributed file system(hdfs) with Apache
Drill to query files on hdfs system?
Thanks
Kartik
~~
This e-mail message from State
On Tue, Jun 9, 2015 at 11:42 AM, Jason Altekruse altekruseja...@gmail.com
wrote:
*We do not currently have a shortcut to read files in the directory where
you launched Drill.*
This has made me grumpy in the past, but I really think that Drill got it
right here.
The real problem is that with
The function from_unixtime() is actually a Hive UDF and drill doesn’t yet
know how to deal with the 2 extra bytes returned from it. It’s better to
use the Drill function to_timestamp():
select to_timestamp(1432912733) from `sys`.`version`
Chris mattacma...@mapr.com
215-701-3146
On Tue, Jun 9,
Hello,
We are trying to 'flatten' out a multi level (nested) json file that is the
result of a REST API call. We were going to try flatten out this to a CSV,
load it into Oracle tables and then do traditional SQL queries. The initial
approach was going to be done using a combination of CSVKIT
My fault, I had a greedy regular expression that was replacing the space in
the value “Basic Authentication” with nothing.
It’s working now.
Some people, when confronted with a problem, think “I know, I’ll use
regular expressions.” Now they have two problems.
Thanks guys.
Chris
It's currently not supported. It would require an enhancement to the
storage plugin.
Feel free to file an enhancement jira, or f you want to experiment with it
yourself, you can take a look at the HBaseGroupScan code, which is where
the assignment logic is located. Currently, we don't split the
Please see http://apache.github.io/drill/docs/file-system-storage-plugin/
and please let us know if you have any problems with these instructions.
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Tue, Jun 9, 2015 at 5:00 PM, Kartik Bhatia kbha...@scif.com wrote:
Hi,
I have