Will Drill Leverage Hive indexing

2016-11-17 Thread Raghu Ram Reddy Medapati
If we index a table in hive, Will drill leverage indexing while querying the hive table with hive plugin in drill. -- Thanks, Raghu.

Drill on Kudu

2016-11-17 Thread MattK
If I understand Kudu correctly, it manages its own cluster, and does not rely on ZK for coordiantion (?). When using the Kudu storage configuration in Drill 1.7/8, is it necessary to run multiple Drillbits, and is there a concept of data locality with Drill on Kudu? Or is a single standalone D

Re: Drill where clause vs Hive on non-partition column

2016-11-17 Thread Robert Hou
Let me clarify my comment regarding the Hive plugin. We plan to support parquet filter pushdown with the Hive plugin when using our native reader (there is an option you can set). This will be at some point in the future. Thanks. --Robert On Thu, Nov 17, 2016 at 3:46 PM, Robert Hou wrote: >

Re: Drill where clause vs Hive on non-partition column

2016-11-17 Thread Robert Hou
There will be some support for Hive tables in 1.9. It will use the dfs plugin but not the Hive plugin. Support for the Hive plugin is planned for the future, but it is not committed at this time. There will be a ticket soon. Thanks. --Robert On Thu, Nov 17, 2016 at 1:31 PM, Sonny Heer wrote:

Re: Drill where clause vs Hive on non-partition column

2016-11-17 Thread Sonny Heer
Ok thanks Rahul. Yeah we have to use the hive plugin I believe since we don't control the sql generated. The reason I ask if its tracked is because you mentioned it was going to be part of 1.9 ...? On Wed, Nov 16, 2016 at 11:26 AM, rahul challapalli < challapallira...@gmail.com> wrote: > Assume

RE: RDBMS Storage Plugin for Apache Drill

2016-11-17 Thread Amar Gunturi
Forgot to mention, I have placed the JDBC jar files as mentioned in the documentation in the /installdir/ jars/3rdparty folder. The SQL Server drivers I have used are version sqljdbc41.4.2.6420.100.jar Amar Gunturi {MCP Azure Infrastructure Solutions, OCS OBIEE 11G, Six Sigma Green Belt} Sr.Syst

RDBMS Storage Plugin for Apache Drill

2016-11-17 Thread Amar Gunturi
Hello Team, I have been trying to add the RDBMS storage plugin to my Apache Drill installation using the below syntax, but I get an error as "Please retry: error (unable to create/ update storage)" { type: "jdbc", enabled: true, driver: "com.microsoft.sqlserver.jdbc.SQLServerDriver", ur

Netezza jdbc error

2016-11-17 Thread Carlos Manuel Fernandes (DSI)
Hello, I'm new on Apache Drill, I just installed the embedded version and successful make queries on cvs file. Its great and revolutionary to make sql queries on text files or json files. Now I'm trying to connect Drill with Jdbc sources: Netezza, Oracle and BD2. I Successful create a connec

Re: Question regarding CTAS Command

2016-11-17 Thread François Méthot
Here is a workaround to insert large *batch *of data, each batch insert is done on their own partition. create table hdfs.`/mytable/1` as (select) Later on, If you want to insert new batch of data to the same table: create table hdfs.`/mytable/2` as (select) Then when you query select

Re: Question regarding CTAS Command

2016-11-17 Thread Arina Yelchiyeva
Hi Sanjiv, currently Drill doesn't support insert or update of data in tables. Kind regards Arina On Thu, Nov 17, 2016 at 3:54 PM, Sanjiv Kumar wrote: > Hello > I have one doubt. In Drill we can create table using CTAS Command. > Like :- CREATE TABLE new_table_name AS ; > > As Mention

Question regarding CTAS Command

2016-11-17 Thread Sanjiv Kumar
Hello I have one doubt. In Drill we can create table using CTAS Command. Like :- CREATE TABLE new_table_name AS ; As Mention in official site:- http://drill.apache.org/docs/create-table-as-ctas-command/ My query is:- Is it possible to update or insert data in CTAS Created Table? -- Th