Drill 3290 aims to add support for complex Hive types, and looks to me like
it's targeted for 1.2.0.
The way I'm understanding it, supporting hive complex types means that if I
create a hive table, stored say as parquet with a MAP column, I should be
able to query it in Drill in the way we'd
The patch for DRILL-3153 (https://issues.apache.org/jira/browse/DRILL-3153)
just got merged yesterday, so tools that use getIdentifierQuoteString()'s
result to create delimited identifiers should stop seeing quoting errors once
1.2 is out.
(There's also an open JIRA report (DRILL 3510) for
I started looking into this few weeks back, but haven't made much progress
in implementation.
Hive MAP type and Drill MAP type are different. Hive MAP is a pure (key,
value) structure. Drill MAP is more like Hive STRUCT type. Both Hive types
MAP and STRUCT are going to be mapped to Drill MAP
Thanks, but I'm still not clear on what this will mean to the user querying
a hive table with complex types.
Will they be able to query the map in the way they expect based on their
experience with Hive, or will they have to be aware of the parquet schema?
Today, the complex types in hive-created
Don’t have Excel on Windows to test, but perhaps uninstall, remove all files
and then reinstall the ODBC driver.
Did you have an earlier version of the ODBC driver installed on your system?
—Andries
On Aug 26, 2015, at 4:34 PM, Xiao Yang xiao.yan...@gmail.com wrote:
Thank you.
What
Yeah thats a good way and i will look to write and UDF for my case.
Thank you
*RegardsMuthupandi.K*
*muthupandi.strikingly.com http://muthupandi.strikingly.com*
Think before you print.
On Thu, Aug 27, 2015 at 11:30 AM, Tomer Shiran tshi...@dremio.com wrote:
columns[31] is a string
columns[31] is a string (VARCHAR), not an array? FLATTEN only works on
arrays. You need to split the string into an array. I don't think Drill has
a SPLIT function yet but it's possible to write a UDF to do that.
Does that make sense?
On Wed, Aug 26, 2015 at 10:45 PM, Muthu Pandi
Hi Drill support,
I am trying to setup Drill with simple authentication.
I followed the instructions but theye seemed only for distributed mode.
I am inable to effect a startup in embedded mode.
Please can you point me at some resources.
Many thanks,
George Pongracz
The information in this
Thank you!
On Tue, Aug 25, 2015 at 11:46 AM, Jason Altekruse altekruseja...@gmail.com
wrote:
Drill supports ILIKE for case insensitive matching. Be aware that it is
treated like a regular function, as Steven notes here:
https://issues.apache.org/jira/browse/DRILL-3301
This doc page should
Ted Dunning wrote:
The cartesian join approach will produce an enormous stream of data with
only a very small amount of disk read.
You don't even need an external seed file (or to query a built-in table), and
using WITH can extend multiplication to exponentiation:
WITH q(key) AS (
WITH
10 matches
Mail list logo