The following restrictions are based on using Cloudera Impala version 1.0:

  • No support for transactions
  • No support for canceling a running query
  • No support for row-level inserts, updates, or deletes
  • No support for cursors or scrollable cursors
  • No support for prepared statements

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

http://www.cloudera.com/content/support/en/documentation.html

Note: Note that Cloudera Impala is not designed for OLTP workloads and does not offer real-time queries or row-level updates. 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.