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 not recommended for production
because bottlenecks develop in data transfer to Spark.
Writes through HWC, however, do not use JDBC mode and are recommended for production.
- 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.