October 15, 2018 at 3:41 am
Hi,
So first up this is not a 2017 issue but in fact is actually a 2019 CTP issue.
I've been trying to play around with Polybase to see how it may be of use to us and I've hit a bit of an issue.
I've managed to create the data source and its all fine, where it goes wrong is with the command to create the file format.
CREATE EXTERNAL FILE FORMAT textfileformat
WITH (
FORMAT_TYPE = DELIMITEDTEXT,
FORMAT_OPTIONS (FIELD_TERMINATOR ='|',USE_TYPE_DEFAULT = TRUE)
)
When I try and run this I just get back
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'EXTERNAL'.
And I cant figure out where I'm going wrong here, I've seen others had issues similar to this creating the data source but I've done that and the fix to that was a reboot, this has been rebooted several times already.
I've even tried using the template SSMS gives me when I click new and that generates the same issue.
I wondered if anyone else had this issue and was able to resolve it.
Thanks,
Nic
October 15, 2018 at 4:22 am
Hi,
The same code works in 2017 so I think M$ must have changed the syntax a little and as its not out yet the documentation is not available.
Now my issue is
OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 10061, Level 16, State 1, Line 0
TCP Provider: No connection could be made because the target machine actively refused it.
This is going to be fun to fix.
Thanks,
Nic
October 15, 2018 at 4:39 am
And that was caused because the PolyBase services were not running, they weren't running as TCP was not enabled for the SQL Server.
Hope this helps others.
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply