Querying external JDBC tables

Learn how you can read the data in an JDBC external table that you have created and mapped to a remote database.

Querying or reading external JDBC tables is the same as querying regular tables in Impala. You can use SELECT statements to query data and can also join the external table with other tables across databases. However, do note that the metadata for the external tables is not persisted in Hive Metastore (HMS).
Run the SELECT statement to read data from the JDBC external table.
SELECT * FROM student_jdbc;