Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

ODBC in visual analytics

Reply
Occasional Contributor
Posts: 19

ODBC in visual analytics

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?

Super User
Posts: 4,030

Re: ODBC in visual analytics

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.

Occasional Contributor
Posts: 19

Re: ODBC in visual analytics

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


Super User
Posts: 4,030

Re: ODBC in visual analytics

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

Ask a Question
Discussion stats
  • 3 replies
  • 202 views
  • 0 likes
  • 2 in conversation