Hey Kevin,
It looks like the storageplugin.workspace.table_path are specified with
single quotes (' ') instead of back-ticks (` `). Is that a email formatting
issue, or the actual syntax with your query? If latter, can you try
correcting it? Also a note in general: you do not need those back-ticks
unless you are using a reserved word or a period (.).
Regards,
Abhishek
On Mon, Oct 8, 2018 at 10:41 AM Kevin Porsolt <[email protected]>
wrote:
> Hello, I am looking to configure Apache Drill as an application between
> our data sources and Spotfire as a way to preserve robust files, while also
> limiting the stress put on our downstream BI applications. I got though 90%
> of the configuration setup, but identified a syntax issue between the view
> created in Drill Explorer and the view read in from ODBC and attempted to
> be loaded into Spotfire. I tried copying and pasting the created view
> directly from Drill Explorer into the Spotfire data connection setup, so
> the view and the table are correctly connected, I just keep on getting a
> "table does not exist" error due to the syntax issue. I added some
> additional details below. We are currently using Hadoop and Spark in our
> technical architecture, so being able to fix this issue and implement
> Apache Drill would provide a lot of opportunity. Thank you
>
> Apache Drill:
> SELECT * FROM 'dfs'.'tmp'.'my_sql_pel_query' LIMIT 100
>
> Spotfire:
> SELECT
> 'dfs.tmp'.'my_sql_pel_query'.*
> FROM
> 'dfs.tmp'.'my_sql_pel_query'
>
> **notice the missing ' ' in 'dfs.tmp'
> This is the field that it seems to be reading from the ODBC
>
> Spotfire.Dxp 56f0-4d14 EXIT SQLGetData with return code
> 0 (SQL_SUCCESS)
>
> HSTMT 0x000000001BAD4260
>
> UWORD 2
>
> SWORD -8
> <SQL_C_WCHAR>
>
> PTR 0x0000000022B20210 [
> 14] "dfs.tmp"
>
> SQLLEN 4094
>
> SQLLEN * 0x000000002AB5DC90 (14)
>
>
>
>
>
>
>
>
> Kevin D Porsolt
> Technical Product Manager
> t: 646-839-9385 | m: 732-213-9621
>
> CROSSIX | Data Driven. Data Proven. | crossix.com<http://crossix.com/>
>
>
>
> ---------------------------------------------------
>
> This message and any attachment are confidential and may be privileged or
> otherwise protected from disclosure. If you are not the intended recipient,
> please telephone or email the sender and delete this message and any
> attachment from your system. If you are not the intended recipient you must
> not copy this message or attachment or disclose the contents to any other
> person.
>
> For further information about Crossix please see our website at
> http://www.crossix.com.
>
