Loading data in an oracle table from a file using sqlldr

We will see how to load data from a file in an oracle table using sqlldr. Table We have a table EMPLOYEE in the oracle database with the following schema:- SQL> desc EMPLOYEE;  Name                                      Null?    Type  —————————————– ——– —————————-  EMP_ID                                    NOT NULL NUMBER(38)  EMP_NAME                                           VARCHAR2(500)  EMP_AGE                                            NUMBER(38) Data File We…

Continue reading

Java Code for Running HIVE queries through JDBC

In this article we will see how to run Hive queries through JDBC. We are using apache-hive-1.0.1 and hiveserver2 is running on port 10000 on localhost. Jars Required To access Hive through JDBC we need to add the following jars in the classpath:- guava-18.0.jar hive-common-1.0.0.jar hive-exec-0.13.0.jar hive-jdbc-1.0.0.jar hive-metastore-1.0.0.jar hive-serde-1.0.0.jar hive-service-1.0.0.jar…

Continue reading

What is JDBC?

JDBC(Java Database Connectivity) provides a standard Java API (Application Programming Interface) for accessing different database systems. JDBC provides a simple, database-independent set of APIs. Using the same APIs we can access a number of database systems in Java. Components of JDBC 1) Driver For connecting to the database we need…

Continue reading