645 questions
0
votes
1
answer
69
views
Apache Drill fails to start: NoClassDefFoundError - org.apache.hadoop.security.SecurityUtil
I'm currently trying to set up Apache Drill with S3 (MinIO) storage plugin support, but Drill crashes during startup or plugin usage with the following error:
Exception in thread "main" java....
user30652712
0
votes
1
answer
45
views
Use PostgreSQL syntax with Apache Drill
I'm trying to use PostgreSQL syntax with Apache Drill but it raises an error.
This syntax (MySQL) works fine :
SELECT DISTINCT (gene)
FROM my.df.genes ;
but this one (PostgreSQL) doesn't :
SELECT ...
- 455
0
votes
1
answer
45
views
object not found in the file system
I installed Apache Drill and a test file in a directory.
While select on this file I have the error :
apache drill> select * from dfs.`/home/fabrice/WORK/test_parquet/test_parquet.tsv`;
Error: ...
- 455
1
vote
0
answers
41
views
Apache Drill VALIDATION ERROR: Expected columns count differs from the returned one
I am trying to query a table in oracle database using apache-drill.
The query is :
SELECT * FROM <storage_plugin>.<schema>.<table> LIMIT 10;
and getting this error.
org.apache.drill....
- 11
0
votes
2
answers
66
views
Apache:Drill cannot create view
I'm new to Apache Drill. I tried to put files from both workspaces in one view to see the convenience query, but there was an error.
I tried to use SQL statements to build views to integrate data from ...
- 61
0
votes
1
answer
75
views
Apache Drill cannot read windows local files
I'm new to Apache Drill. I want to try to use Drill to manage local data and configure the data storage path in the JSON file, but when I use SQL syntax to query the data, I can't read the local file.
...
- 61
0
votes
1
answer
64
views
How to connect and query Neo4j Database on Apache Drill?
I am using Apache Drill and Neo4j Database for a project. The database needs to be connected to Drill and I should be able to query the data from Apache Drill.
I have copied and pasted neo4j-driver-4....
- 155
0
votes
1
answer
86
views
How to get column names from JSON file in Apache Drill
I am trying to work with JSON files validation using Apache Drill. I am working with both linear and nested JSON data. I have stored the JSON file in Drill tmp storage dfs/tmp/employee_src_reg_json....
0
votes
1
answer
97
views
enable admin access for a user in apache drill UI
I have enabled user authentication in drill using Custom Authenticators.
I am following guide from https://drill.apache.org/docs/creating-custom-authenticators/
Implemented the class with a hard ...
- 564
0
votes
1
answer
46
views
Apache Drill won't load because of a space in the path for Java?
I'm trying to get started with Apache Drill and following the 10 minute tutorial.
When I run bin/drill-embedded I get the following error:
/Users/breuds/Desktop/Drill/apache-drill-1.21.1/bin/sqlline: ...
- 4,092
0
votes
1
answer
77
views
How to include escape character as part of column value in a csv file while using apache drill?
I have a csv file like this-
"id"^"first_name"^"last_name"^"email"^"gender"
"1"^"John"^"143 \\"^"ewilkes0@buzzfeed....
- 43
1
vote
1
answer
44
views
Can Apache Drill query a list of files with updated data?
I have a large (more than 8.5GB) CSV file that is updated on the first day of each month. But from the 2nd to the last day of each month, it can have new updated data in the JSON format.
I convert ...
- 841
0
votes
1
answer
319
views
Dataset created with Apache Drill+MongoDB does not include columns where values are null or empty arrays
I have connected Apache Superset to MongoDB through Apache Drill. When querying in Apache Drill Web UI, all data is shown correctly.
Im trying create a dataset with a schema in MongoDB, but it creates ...
- 1
1
vote
2
answers
290
views
PostgreSQL connection in Apache-Drill
I am trying to get Apache Drill to connect to a PostgreSQL database using the following configuration
# storage-plugins-override.conf
"postgresql": {
"type": "jdbc&...
- 621
0
votes
1
answer
46
views
Error connecting to google cloud and query the parquet file in apache drill
I have a parquet file in google cloud bucket which I want to make a query upon.
As per one of the answer mentioned I have added the configuration in core-site.xml under $DRILL_HOME/conf as below-
<...
