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.