sas~hadoop via odbc vs coluderaimpala

[nayakig]

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 ??????

[SASKiwi]

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. 

[nayakig]

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

[JuanS_OCS]

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.

[nayakig]

its the same user and schema

the only differnce is sasioimp and odbc in the libnames

[LinusH]

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.

[nayakig]

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