apache-drill Questions
6
I'm using drill in embedded mode, and I can't figure out how to save query output other than copy and pasting it.
Dove asked 23/6, 2015 at 23:1
2
Solved
I would like to create a Spark SQL DataFrame from the results of a query performed over CSV data (on HDFS) with Apache Drill. I successfully configured Spark SQL to make it connect to Drill via JDB...
Freeze asked 18/2, 2016 at 8:15
1
I'm working on a SQLAlchemy dialect for Apache Drill and I've run into an issue that I can't quite seem to figure out.
The basic problem is that SQLAlchemy is generating a query like the one belo...
Manofwar asked 16/12, 2016 at 5:24
3
Solved
I have some expirience with Apache Spark and Spark-SQL. Recently I've found Apache Drill project. Could you describe me what are the most significant advantages/differences between them? I've...
Courtenay asked 22/4, 2015 at 7:29
3
I am trying to query Cassandra using Apache Drill. The only connector I could find is here:
http://www.confusedcoders.com/bigdata/apache-drill/sql-on-cassandra-querying-cassandra-via-apache-drill
...
Todhunter asked 24/6, 2015 at 4:40
1
Solved
I am trying to use Apache Drill to export a .csv file. This other question indicated that this is achieved by:
use dfs.tmp;
alter session set `store.format`='csv';
create table dfs.tmp.my_output ...
Sello asked 3/8, 2019 at 16:14
4
Solved
Throughout the Wiki of Apache Drill, I could only see queries running via SqlLine client. Is there any programmatical way to run queries in Drill other than the REST API? Any samples or pointers?
...
Ranson asked 4/4, 2015 at 7:3
2
I tried using apache-drill to run a simple join-aggregate query and the speed wasn't really good. my test query was:
SELECT p.Product_Category, SUM(f.sales)
FROM facts f
JOIN Product p on f.pkey =...
Bolling asked 19/9, 2016 at 22:27
1
I am trying to start Apache Drill 1.10 in Embedded Mode on Windows 10 x64 (with Oracle JVM 1.8.0_131). When launching the command
sqlline.bat -u "jdbc:drill:zk=local"
I get the following:
Erro...
Mackenie asked 24/5, 2017 at 9:50
1
Solved
I've been hunting around for a solution to this question.
It appears to me that there is no way to embed reading and writing Parquet format in a Java program without pulling in dependencies on HDF...
Dwyer asked 6/2, 2017 at 22:53
2
Solved
Are there any performance benchmark(genuine ones) that compare Stinger vs Impala vs Drill? Also, which is preferred - my use case will be mainly towards ad-hoc interactive queries on top of Hive. T...
Metopic asked 22/8, 2015 at 6:44
1
Solved
I want to access Drill through a programming interface. The Apache Drill documentation just mentions about its JAVA and C++ libraries for the client to connect but doesn't provide any documentation...
Danndanna asked 27/5, 2015 at 10:34
8
Solved
I need to develop application that can be getting data from multiple data sources ( Oracle, Excel, Microsoft Sql Server, and so on) using one SQL query. For example:
SELECT o.employeeId, count(o....
Killingsworth asked 20/1, 2016 at 11:3
4
I want to connect to Drill by Java app, and so far I was trying to use JDBC to do it and I'm using example from https://github.com/vicenteg/DrillJDBCExample, but...
when I change DB_URL static var...
Glorious asked 27/7, 2015 at 13:38
3
Motivation: I want to load the data into Apache Drill. I understand that Drill can handle JSON input, but I want to see how it performs on Parquet data.
Is there any way to do this without first l...
Ballesteros asked 11/2, 2014 at 0:54
2
Solved
I want to do some "near real-time" data analysis (OLAP-like) on the data in a HDFS.
My research showed that the three mentioned frameworks report significant performance gains compared to Apache Hi...
Sensibility asked 25/6, 2013 at 6:18
1
© 2022 - 2024 — McMap. All rights reserved.