JDBC mode limitations
You must understand the limitations of JDBC mode and what functionality is not supported.
Keep the following limitations of JDBC mode in mind:
- JDBC_CLUSTER and JDBC_CLIENT are used for reads only, and are recommended for production
workloads of 1 GB or less. With larger workload bottlenecks develop in data transfer to
Spark.
Writes through HWC of any size are recommended for production. Writes do not use JDBC mode.
- In JDBC_CLUSTER mode, HWC fails to correctly resolve queries that use the ORDER BY clause
when run as
hive.sql(" <query> ")
. The query returns unordered rows of data even though the query contains an ORDER BY clause.