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.

Insert query is very is very slow using Cloudera ODBC Driver for Impala

Highlighted

Insert query is very is very slow using Cloudera ODBC Driver for Impala

New Contributor

We are using Cloudera ODBC Driver for Impala to insert data to Hive in a C# application. A simple insert statement with 3 columns takes 10 seconds to complete. We have 1M records to insert every day and the performance is not acceptable. Please suggest, how can we improve the performance.

1 REPLY 1

Re: Insert query is very is very slow using Cloudera ODBC Driver for Impala

Master Collaborator

Ingesting via insert statements is not the preferred method for bulk ingestion - most users will ingest other ways - e.g. streaming ingest by kafka, nifi, spark streaming, etc, or bulk ingest by copying data files into the cluster then ETL in SQL.

 

If you want help debugging the performance of a query, you're most likely to get actionable advice if you attach a query profile.

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