Hello team,   We are facing issue and expecting your help here regarding  Problem Statement : We create groups using in Cloudera user management using APIs. We can see those groups in Cloudera user management but not  could not find them as Ranger Groups. It seems groups are not being synced in Ranger. What are the possible solutions ?  Any API is exist to sync users and groups? ... View more

  Is there any way to cast string to map in Impala? e.g:  select cast("A:1,B:1,C:1") as map<string, int>   ... View more

Impala is not supporting org.apache.hadoop.hive.serde2.OpenCSVSerde SerDe class. Please suggest the solution.   Table aggregate_test is created using Hive and org.apache.hadoop.hive.serde2.OpenCSVSerde SerDe class.   Following query is not working: SELECT * from open_aggregate_test.aggregate_test ;   Above query gives following error: SQL Error [500051] [HY000]: [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Failed to load metadata for table: 'open_aggregate_test.aggregate_test' CAUSED BY: TableLoadingException: Could not load table open_aggregate_test.aggregate_test from catalog CAUSED BY: TException: TGetPartialCatalogObjectResponse(status:TStatus(status_code:GENERAL, error_msgs:[TableLoadingException: Failed to load metadata for table: open_aggregate_test.aggregate_test CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hadoop.hive.serde2.OpenCSVSerde' is not supported.]), lookup_status:OK) ), Query: SELECT * from open_aggregate_test.aggregate_test. ... View more