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.

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

1 Answer 1

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

Your Answer

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

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