Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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.


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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.