04-13-2018 06:21 PM
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 ??????
04-13-2018 07:18 PM
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.
04-16-2018 06:15 PM - edited 04-16-2018 06:16 PM
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
04-14-2018 02:12 PM
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.
04-15-2018 07:07 AM