Ok @MGreen , thanks for your help! ... View more

Thanks, but the reason I'm trying to establish an ODBC connection is because I'm using R. ... View more

Hi @szhao , based on the symptoms this may be a problem within the ODBC driver. Can you please open a support ticket through the MyCloudera support portal so that our support team can forward these information to our driver team? Thanks, Miklos ... View more

We are experiencing the same issue on CDP 7.1.7 calling a spark job from Oozie. ... View more

Hi had checked the "show processlist" and this query is running there and multiple time it's running problem is that it is scanning all rows, means not in optimize state and if it is auto generated query then how we can pass the partition information. and this query is not run by user, they are running optimize query it seems it taking some metadata from mysql, something like below..... So that's why i was thinking it meta generated query.  | id | select_type | table | partitions | type  | possible_keys                    | key             | key_len | ref         | rows    | filtered | Extra       | +----+-------------+-------+------------+-------+----------------------------------+-----------------+---------+-------------+---------+----------+-------------+ |  1 | SIMPLE      | C0    | NULL       | const | PRIMARY,UNIQUE_DATABASE,CTLG_FK1 | UNIQUE_DATABASE | 389     | const,const |       1 |   100.00 | Using index | |  1 | SIMPLE      | B0    | NULL       | const | PRIMARY,UNIQUETABLE,TBLS_N49     | UNIQUETABLE     | 268     | const,const |       1 |   100.00 | Using index | |  1 | SIMPLE      | A0    | NULL       | ref   | PARTITIONS_N49                   | PARTITIONS_N49  | 9       | const       | 5555098 |    11.11 | Using where ... View more

Thanks @ldylag for sharing the details, that makes sense. The CM does not necessarily need the PostgreSQL driver to be installed, of course it's needed only when that database type is configured for CM. The one under the "/opt/cloudera/cm/lib" might be shipped to support the "embedded" database, that might have caused a confusion here (if one HMS is on the CM host), but in general the DB drivers are expected to be under the "/usr/share/java". Cheers  Miklos ... View more

To retrieve data records after crm enrichment added since the last time you polled an Impala table using a Date/Timestamp column, you can use a SQL query with a WHERE clause filtering for records with timestamps greater than the last timestamp you retrieved. Here's a basic example assuming your timestamp column is named timestamp_column: SELECT * FROM your_table WHERE timestamp_column > 'last_poll_timestamp';   Replace 'last_poll_timestamp' with the actual timestamp value you stored from your last poll. Make sure the timestamp format matches the format stored in your table. Here's a step-by-step guide: Store the timestamp of the last poll in your source system. Use this timestamp to construct your SQL query, ensuring you're retrieving records with timestamps greater than the last poll timestamp. Execute the SQL query against your Impala table to retrieve the new records. ... View more

Hello @DianaTorres, I've tried to follow the instructions & looked around a few changes in our configuration, but I can't easily figure out the solution; it might be simple, but it's my first look / attempt at this setup. I've tried to create a Cloudera support case but couldn't, it seems I don't have the rights. Could you create one on my behalf ? As a reminder of the issue : - We are informing two realms in the conf file - When attempting a connection, and specifically with Hive where the error pops-up, it seems like the process only takes into account the default realm. - As we have two tickets simultaneously, one for each realm, the connection fails, likely because it does not find the right credentials of the ticket to the right domain. ... View more

The error message was related to a date field being used in a Parameter. I set up a Parameter to update to the newest date when the workbook opened. The date addition caused an issue with the refresh. ... View more