Re: hive connection as generic jdbc

2018-03-13 Thread Arjun kr
Hi Asim, Can you try using below jar? It looks like hive 1.2 onwards, Hive uses httpclient version 4.4. The previous versions of Hive uses httpclient version 4.2.5. You may try with hive 1.1.1 standalone jar to see if it helps. http://central.maven.org/maven2/org/apache/hive/hive-jdbc/1.1.1/h

Different output for the same date field

2018-03-13 Thread Jiang Wu
Setup: 1. Mongodb with this sample data inside: db.test.findOne(); { "_id" : ObjectId("5aa8487d470dd39a635a12f5"), "name" : "orange", "context" : { "time" : ISODate("2018-03-13T21:52:54.940Z"), "user" : "jack" } } 1. Connect with Drill 1.12 and r

Re: hive connection as generic jdbc

2018-03-13 Thread Asim Kanungo
Hi Arjun, With that I am getting error while starting the drill bit. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/apache-drill-1.12.0/jars/3rdparty/hive-jdbc-1.1.1-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:fi

Re: Different output for the same date field

2018-03-13 Thread Kunal Khatua
Hi Jiang Thanks for bringing this to our attention. However, we're not actively developing the Mongo storage plugin at the moment, so it might be a while before this is updated. Do you think you could help with submitting a pull-request against a JIRA filed for this? You already appear to have b

Single (embedded) drillbit as a service

2018-03-13 Thread Krzysztof Kowalczyk
Hi, I would like to have and ad-hoc deployment of Drill on a linux box working with relatively small dataset, thus I don't want to use Zookeeper, but I find drill shell scripts actively restricting such usage. The `drillbit.sh start` will not work without zookeeper (or would it?) and is explicitl

Re: Single (embedded) drillbit as a service

2018-03-13 Thread Kunal Khatua
The trouble with your approach is that making it a background process pauses the process in an interactive mode, until you bring it to the foreground. You cannot use an Embedded Drillbit with Zookeeper. You should start it off as a regular drillbit instance. Zookeeper only serves the purpose of c

Re: [Drill 1.12.0] : RESOURCE ERROR: Not enough memory for internal partitioning and fallback mechanism for HashAgg to use unbounded memory is disabled

2018-03-13 Thread Anup Tiwari
Hi Kunal, Please find below cluster/platform details :- Number of Nodes : 5 RAM/Node : 32GBCore/Node : 8DRILL_MAX_DIRECT_MEMORY="20G"DRILL_HEAP="8G"DRILL VERSION = 1.12.0HADOOP VERSION = 2.7.3ZOOKEEPER VERSION = 3.4.8(Installed in Distributed Mode on 3 nodes)planner.memory.max_query_memory_per_node

Re: [Drill 1.12.0] : RESOURCE ERROR: Not enough memory for internal partitioning and fallback mechanism for HashAgg to use unbounded memory is disabled

2018-03-13 Thread Anup Tiwari
JSON Profile when Succeeded :- {"id":{"part1":2690693429455769721,"part2":6509382378722762087},"type":1,"start":1521007764471,"end":1521007906770,"query":"create table a_games_log_visit_utm as\nselect\ndistinct\nglv.sessionid,\ncase when (UFG('utms=', glv.url, '&') <> 'null') then UFG('utms=', gl