Java
When trying to start Hadoop DFS services in WSL (Windows Subsystem for Linux), it failed with the following error: 2021-01-01 21:13:37,650 INFO org.apache.hadoop.http.HttpServer2: HttpServer.start() threw a non Bind IOException java.net.BindException: Port in use: 0.0.0.0:9870 at ...
MySQL: The server time zone value 'AEDT' is unrecognized or represents more than one time zone
When connecting to MySQL using JDBC driver, the following error is encountered: Underlying cause: java.sql.SQLException : The server time zone value 'AEDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' ...
Install JDK 11 on macOS
JDK (Java Development Kit) is required for many big data frameworks such as Hadoop, Spark, Hive, etc. Follow these steps to install JDK SE 11 on macOS. The steps were tested on Big Sur. Go to JDK 11 download page: Java SE Development Kit 11- - Downloads (oracle.com) . Download ...
Find JAVA_HOME JDK Location on macOS
This article provides the steps to locate Java JDK location on macOS. The system version is 11.1 (macOS Big Sur). Open Terminal . Change directory to /Library/Java/JavaVirtualMachines . cd /Library/Java/JavaVirtualMachines List JDKs: ls In my system, there are two SDKs (JDK8 and ...
Python JayDeBeApi module allows you to connect from Python to Teradata databases using Java JDBC drivers. In article Connect to Teradata database through Python , I showed how to use teradata package to connect to Teradata via Teradata ODBC driver. This article demos how to use this JayDeBeApi ...
When I was configuring Hive 3.0.0 in Hadoop 3.2.1 environment, I encountered the following error: Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V This issue happened because guava lib ...
Python: Read Data from SQLite via JDBC
To read data from SQLite database in Python, you can use the built-in sqlite3 package . Another approach is to use SQLite JDBC driver via JayDeBeApi python package. Download the JAR file from one of the online repositories: Maven Repository BitBucket or any other equivalent ...
In my previous article Connect to SQL Server via JayDeBeApi in Python , I showed examples of using Python package jaydebeapi to connect to SQL Server via JDBC. The code was working properly. However after I reinstall Python 3.8.2 x64 version on Windows, I'm getting a new error ...
With Microsoft SQL Server JDBC driver, you can connect to the database through SQL Server Authentication or Kerberos Authentication. This post summarizes the configurations required for each authentication method with coding examples. *NTLM block in the following diagram represents pure Java ...
This post shows you how to connect to HiveServer2 via Hive JDBC driver in Java. *The way to connect to HiveServer1 is very similar though the driver names are different: Version Driver Name HiveServer1 org.apache.hadoop.hive.jdbc.HiveDriver HiveServer2 ...
