Please note the following Apache Impala functional limitations:

  • No support for transactions
  • No support for canceling a running query
  • No support for row-level updates or deletes
  • No support for stored procedures
  • No support for auto-generated keys

For a more complete listing of known issues and limitations for your version of Apache Impala, refer to the Apache Impala user documentation:

https://impala.apache.org/docs/build/plain-html/index.html

Note: Apache Impala is not designed for OLTP workloads and does not offer row-level updates or deletes. Instead, Impala is designed for batch type jobs over large data sets with high latency. This means that queries such as "SELECT * FROM mytable" return quickly. However, other SELECT statements are much slower.