Adding external table to sql 2019 fails

[dawazualex]

Issue Type: Bug

Try to add an Oracle external table, after attempting to create a connection to my data source, I get an error "external data sources are not supported with type GENERIC"

Azure Data Studio version: azuredatastudio 1.0.0 (cab8f3e, 2018-09-20T22:04:35.897Z)
OS version: Windows_NT x64 10.0.16299

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-7700 CPU @ 3.60GHz (4 x 3600)
GPU Status	2d_canvas: enabled checker_imaging: disabled_off flash_3d: enabled flash_stage3d: enabled flash_stage3d_baseline: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on native_gpu_memory_buffers: disabled_software rasterization: enabled video_decode: enabled video_encode: enabled webgl: enabled webgl2: enabled
Memory (System)	31.90GB (20.58GB free)
Process Argv	D:\Program Files\Azure Data Studio\azuredatastudio.exe
Screen Reader	no
VM	0%

Extensions (5)

Extension	Author (truncated)	Version
mssql-db-insights	mat	0.2.2
agent	Mic	0.33.0
import	Mic	0.2.0
server-report	Mic	0.1.3
sql-vnext	Mic	0.6.9

[corivera]

Have you enabled PolyBase in your SQL Server instance?
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-installation?view=sql-server-2017

[dawazualex]

Yes I did. Still get that error. And yes I verified I installed the CTP 2.0. Installed all the features

…

On Thu, Oct 11, 2018 at 4:32 PM Cory Rivera ***@***.***> wrote: Have you enabled PolyBase in your SQL Server instance? https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-installation?view=sql-server-2017 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2819 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABl36d7IOENxDAhaa4yzFITgrEyeqVX-ks5uj6r0gaJpZM4XYF48> .

[corivera]

Are you trying to create this external table through T-SQL, or the External Table wizard in the sql-vnext extension?

[dawazualex]

Both. I get the same error on both. Happy the share my desktop some time?

…

On Thu, Oct 11, 2018 at 4:37 PM Cory Rivera ***@***.***> wrote: Are you trying to create this external table through T-SQL, or the External Table wizard in the sql-vnext extension? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2819 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABl36XwYy2YFybyJ0xSpx2HGwzwnJ_F6ks5uj6vxgaJpZM4XYF48> .

[corivera]

@dawazualex Were you able to resolve this issue?

[dawazualex]

I figured it out. It was an edition issue. Trying to connect to an oracle data source with a ton of tables (1400 +), I'm getting this error when expanding the database to see the list of tables - The user specified schema column count is 55, which varies from the external table schema column count of 65.

…

On Mon, Oct 22, 2018 at 6:50 PM Cory Rivera ***@***.***> wrote: @dawazualex <https://github.com/dawazualex> Were you able to resolve this issue? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2819 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABl36ZdsVMcOiUeuT2vsqx--e0pFB2nyks5unkvDgaJpZM4XYF48> .

[corivera]

Could you open a separate issue for that bug?

[AdeDarbs]

I have a similar issue when trying to Create an External Data Source using TSQL in SQL Server 2019 for the purpose of connecting to MongoDB through PolyBase.

"External data sources are not supported with type GENERIC."

ODBC Drivers installed.

I am thinking that due to SQL Server 2019 being in CTP it may not be working yet.

[kevcunnane]

@AdeDarbs that error message indicates Polybase not being enabled. Per the instructions, install & enable Polybase. In particular you'll want to run the enable polybase command (see below).

exec sp_configure @configname = 'polybase enabled', @configvalue = 1;
RECONFIGURE [ WITH OVERRIDE ]  ;

[AdeDarbs]

Hey Kev. My script does that. Polybase is installed. It must be a SQL config setting surrounding TCP/IP and the 27017 port. Thanks for replying.