I am trying to get Apache Drill to connect to a PostgreSQL database using the following configuration # storage-plugins-override.conf "postgresql": { "type": "jdbc", "driver": "org.postgresql.Driver", "url": "${POSTGRES_URL}", "username": "${POSTGRES_USER}", "password": "${POSTGRES_PASSWORD}", "enabled": true, "sourceParameters": { "minimumIdle": 0, "autoCommit": true, "connectionTestQuery":…
I am trying to setup Superset in my local. I have a windows system, so i used VM Virtual Box, with Ubuntu 22.04 to setup and run the superset. I followed the docker instructions. Used the docker compose up command…
I am new to Kylin and exploring same as well. It would be great if any one help me on below points :- My source is Hbase , how can i connect to Kylin to Hbase and build cube? Can…
I have a huge dataset where each record have json data similar to below - {"project":{"id":"2625","createDate":1542597000000,"rank":0,"highlight":false,"isDisplay":true,"isNewProject":true,"propertyId":2231,"districts":{"id":41,"name":"abc","region":"123"}}} When I am trying to genrate key value pairs using select kvgen(t.project) from dfs.filePath t in apache drill, I am getting below error -…
The instruction: https://blog.minio.io/query-minio-datastore-with-apache-drill-dcaf71d0cee5 Works without problems. Also a query on for example JSON files works. Only the query on parquet files does not work. There are a few hints on the WWW. But they do not really seem conclusive and…