0

I am trying to query Hive tables AND Kylin tables from SQL Server 2019. I was doing some research and found that MSSQL provide PolyBase as a form of interface to Hadoop storage. However, the examples mostly include creating tables and storing file formats into HDFS. All I need is to create an external table from MSSQL using JDBC drivers. Is this possible? I would like to avoid using ODBC drivers.

Improve this question
2
  • Create an external table where?
    – Francesco Mantovani
    Nov 6, 2020 at 12:59
  • Create an external table in MSSQL to link tables in hive or kylin using JDBC drivers
    – user859385
    Nov 6, 2020 at 14:01

1 Answer 1

Reset to default
1

All I need is to create an external table from MSSQL using JDBC drivers. Is this possible?

No. The supported data sources are here:

  • Hadoop
  • Azure Blob Storage
  • SQL Server
  • Oracle
  • Teradata
  • MongoDB
  • ODBC Generic Types

https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.