topic Re: sas~hadoop via odbc vs coluderaimpala in SAS Enterprise Guide

sas~hadoop via odbc vs coluderaimpala

nayakig — Fri, 13 Apr 2018 22:21:16 GMT

We have 2 environments one is GRID another is VA, in grid we are connecting to hadoop/impala to get the tables from a schema, which works great & connection is via cloudera impala drivers !

another environment is VA we are doing the same but connection here is with ODBC drivers !

The issue here is we can see all the tables we are supposed to see in EG(in GRID environment) for a particular schema

But in VA environment we dont see all the tables in EG, some of the tables are missing for the same schema, whats wrong ??????

Re: sas~hadoop via odbc vs coluderaimpala

SASKiwi — Fri, 13 Apr 2018 23:18:19 GMT

Please provide details on how the ODBC libraries been set up. Are they defined with LIBNAME statements or in SAS metadata? If they are defined in metadata, one possible cause for the difference is that all tables are not registered in metadata.

Re: sas~hadoop via odbc vs coluderaimpala

JuanS_OCS — Sat, 14 Apr 2018 18:12:15 GMT

Hello @nayakig,

is the user the same, used in the odbc connection, as the one used in the GRID? Even if schema is the same, different users querying a database might mean different permissions.

Also, the odbc, as connection, might have different permissions. I would like to suggest you to talk to your hadoop/cloudera admin, they should be able to answer your question. If you have none, then perhaps this is a good signal that you might need one.

Re: sas~hadoop via odbc vs coluderaimpala

LinusH — Sun, 15 Apr 2018 11:07:28 GMT

Just to be clear and as I unserstand it, SAS/ACCESS to Impala uses ODBC drivers. Make sure you are using the same version in both environments.
Other than that, it sounds like a permission problem.

Re: sas~hadoop via odbc vs coluderaimpala

nayakig — Mon, 16 Apr 2018 22:16:24 GMT

Its not a metadata library , its done via libname, I have tried registering tables in metadata, all the tables dont show up in the register tables window

Re: sas~hadoop via odbc vs coluderaimpala

nayakig — Mon, 16 Apr 2018 22:17:23 GMT

its the same user and schema

the only differnce is sasioimp and odbc in the libnames

Re: sas~hadoop via odbc vs coluderaimpala

nayakig — Mon, 16 Apr 2018 22:20:11 GMT

hi, thanks for the post, we are using the same version for both..!