Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

druid throws error during data ingestion,Druid throws error when data ingestion

druid throws error during data ingestion,Druid throws error when data ingestion

New Contributor

Hi,

In HDP 4 node cluster, all the druid services are running fine. But when i tried to ingest the sample data as given in the document using curl REST API command. It saying unable to create table DRUID_TASK

Submit command:

curl -X 'POST' -H 'Content-Type:application/json' -d @my-index-task.json <overlord ipaddress>:8081/druid/indexer/v1/task

Derby is configured as metastore

Here the derby connection:

jdbc:derby://localhost:1527/druid;create=true

Below error from the log file overlord.log

Caused by: org.skife.jdbi.v2.exceptions.UnableToCreateStatementException: java.sql.SQLSyntaxErrorException: Table/View 'DRUID_TASKS' does not exist. [statement:"SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date", located:"SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date", rewritten:"SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date"

Please help to fix this issue.

Thanks

1 REPLY 1
Highlighted

Re: druid throws error during data ingestion,Druid throws error when data ingestion

@Srinivasan kg

Ideally, Derby is not suitable for production use as a metadata store. Use MySQL or PostgreSQL instead.

For using MySQL refer link and for Postgres refer link.

For now, you need to login to Derby database and verify, if the tables are created properly or not.

Steps to connect to Derby database:

1. Startup Interactive SQL as:

 java org.apache.derby.tools.ij

2. Connect to DB

connect 'jdbc:derby:druid'

3. Check tables:

show tables;
Don't have an account?
Coming from Hortonworks? Activate your account here