Desktop productivity for business analysts and programmers

sas~hadoop via odbc vs coluderaimpala

Reply
Occasional Contributor
Posts: 19

sas~hadoop via odbc vs coluderaimpala

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

Super User
Posts: 4,018

Re: sas~hadoop via odbc vs coluderaimpala

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. 

Occasional Contributor
Posts: 19

Re: sas~hadoop via odbc vs coluderaimpala

[ Edited ]

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

Trusted Advisor
Posts: 1,839

Re: sas~hadoop via odbc vs coluderaimpala

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.

Occasional Contributor
Posts: 19

Re: sas~hadoop via odbc vs coluderaimpala

Posted in reply to JuanS_OCS

its the same user and schema

the only differnce is sasioimp and odbc in the libnames

Super User
Posts: 5,915

Re: sas~hadoop via odbc vs coluderaimpala

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.
Data never sleeps
Occasional Contributor
Posts: 19

Re: sas~hadoop via odbc vs coluderaimpala

[ Edited ]

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

Ask a Question
Discussion stats
  • 6 replies
  • 177 views
  • 1 like
  • 4 in conversation