topic Re: ODBC in visual analytics in SAS Visual Analytics

ODBC in visual analytics

nayakig — Thu, 15 Mar 2018 19:25:49 GMT

Hi All,

I am trying to access impala tables from VA via ODBC (data explorer-->odbc-->provided parameters like DSN,schema etc..), but I cant.. it says "No tables were returned for the selected library", No error in the log, log says the libname executed successfully..! WHATS WRONG?

Re: ODBC in visual analytics

SASKiwi — Fri, 16 Mar 2018 23:24:24 GMT

A common reason why no tables might be returned is because of an incorrect database or schema name. If this isn't the problem then I would test getting the connection right outside of VA in normal SAS code.

Re: ODBC in visual analytics

nayakig — Fri, 16 Mar 2018 23:28:37 GMT

Yes I did in SASEG/libname, same thing, No tables in library .. remember this is using Cloudera impala drivers that is installed on SAS Server

Re: ODBC in visual analytics

SASKiwi — Sat, 17 Mar 2018 01:18:01 GMT

Please post the LIBNAME you used. I suggest you also open a track with SAS Tech Support.