topic How to use select count(*) from table in db components, while using query getting null pointer exception in Talend Studio

How to use select count(*) from table in db components, while using query getting null pointer exception

Raviteja_yadav — Fri, 15 Nov 2024 21:54:43 GMT

How to use select count(*) from table in db components, while using query getting null pointer exception

Anonymous — Wed, 12 Apr 2023 01:00:20 GMT

Hello @Not defined Not defined ,

Please try the below query like:

select count(*) as num1 from xxxx

You can setup the Column field num1 in tDBInput schema as the below

Best regards

Aiming