Hi, I'm trying to import a query from pgsql into HDFS using sqoop:   --query 'select count(username), date(jointime), productid, flag, currency, credit, sum(totalbet) as tb, sum(bet_count) as bc from customers where credit>= 0 and date(jointime) = cast('2022-01-01' as date) and $CONDITIONS group by date(jointime), productid, credit, flag, currency'   but get the error 'cannot cast type integer into date' due to the specified 1st Jan date..   how can i get around this issue? also when i tried writing date in timestamp version (yyyy-mm-dd hh:mm:ss) that didn't work either ... View more

Hi,   I have been trying to connect to postgres DB using sqoop so i can import a table from there to HDFS; however I keep getting errors and have tried variuos solutions online but none seem to work..   connection string =  sqoop list-tables --connect jdbc:postgresql://"ip of db or localhost":5432/postgres --username yomi --password mypassword   here below is the error im facing on putty and also my config file   the authentication type 10 is not supported. check that you have configured the pg_hba.conf file to include the client's ip address or subnet       pg_hba:     thanks in advance for the help! ... View more