Support Questions

Find answers, ask questions, and share your expertise

Can we connect MariaDB database using Mysql jdbc connector with Sqoop?

avatar

I used this command to list the tables in mariadb database:

sqoop list-tables --connect jdbc:mysql://10.11.11.15:6306/siki_asmet --username micronics -P 

 

I get this error: 

20/09/23 14:41:02 ERROR manager.CatalogQueryManager: Failed to list tables
java.sql.SQLException: The server time zone value 'WIB' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.

1 REPLY 1

avatar
Master Guru

@analytics-shek Please follow the solution given on below thread:

 

https://community.cloudera.com/t5/Support-Questions/Error-setting-up-hive-on-HDP-2-6-5-timezone-on-m...


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.