@adsejnf Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks. ... 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

@Racketmojster Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@donaldo71 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@alan18080 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@Sofia71 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@npdell Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks. ... View more

Hello Again Matt,  I am going to give you more details about my problem. I get this error:      kelpye_2-1716362365779.png I am putting in the NiFi directory my copy. It is structured like that :   kelpye_4-1716362594559.png Then I have my cobol file. I have deleted all rows except 1 ( I have performed various test, full file, few raws ...) and I always ge the same error mentioned above. This is the example of my cobol file with just one row: kelpye_5-1716362800234.png Do you have any clue what is happening?   Thank you very much for your help   ... 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