<dependency>
	<groupId>org.apache.hive.hcatalog</groupId>
	<artifactId>hive-hcatalog-core</artifactId>
	<version>0.13.0</version>
</dependency>

<dependency>
	<groupId>org.apache.hive.hcatalog</groupId>
	<artifactId>webhcat-java-client</artifactId>
	<version>0.12.0</version>
</dependency>

import java.io.BufferedWriter;
import java.io.FileOutputStream;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.Path;
import org.apache.hive.hcatalog.api.HCatClient;
import org.apache.hive.hcatalog.api.HCatTable;
import org.apache.hive.hcatalog.data.schema.HCatFieldSchema;

import com.shukla.pojo.Metadata;

public class ReadTableMetadata {

	public static Map<String, Metadata> getMetadata(String databaseName,
			String tableName) throws SQLException {

		Map<String, Metadata> metadata = new HashMap<String, Metadata>();
		Writer writer = null;
		try {
			writer = new BufferedWriter(new OutputStreamWriter(
					new FileOutputStream("metadata.txt"), "utf-8"));
			Configuration conf = new Configuration();
			conf.addResource(new Path("file:////etc/hive/conf/hive-site.xml"));
			HCatClient client;
			client = HCatClient.create(conf);
			HCatTable hcatTable = client.getTable(databaseName, tableName);
      
			List<HCatFieldSchema> fields = hcatTable.getCols();
			for (HCatFieldSchema field : fields) {
				Metadata m = new Metadata();
				m.setTableName(tableName);
				m.setColumnName(field.getName());
				m.setDataType(field.getTypeString());
				metadata.put(field.getName().toUpperCase(), tm);
				writer.write(field.getName().toUpperCase() + "=" + tableName
						+ "," + field.getName());
				writer.write('\n');
			}
			writer.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
		return metadata;
	}

	public static void main(String[] a) {
		try {

			Map<String, Metadata> metadata = getMetadata("default",
					"orders");
			//do somthing with metadata
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}
}

public class  Metadata{
	@Override
	public String toString() {
		return tableName + ", "
				+ columnName + ", " + dataType + ", "
				+ isPrimary;
	}

	private String tableName;
	private String columnName;
	private String dataType;
	private boolean isPrimary;

	public String getTableName() {
		return tableName;
	}

	public void setTableName(String tableName) {
		this.tableName = tableName;
	}

	public String getColumnName() {
		return columnName;
	}

	public void setColumnName(String columnName) {
		this.columnName = columnName;
	}

	public String getDataType() {
		return dataType;
	}

	public void setDataType(String dataType) {
		this.dataType = dataType;
	}

	public boolean isPrimary() {
		return isPrimary;
	}

	public void setPrimary(boolean isPrimary) {
		this.isPrimary = isPrimary;
	}
}

ORDER_ID=orders,order_id,int
ORDER_DATE=orders,order_date,date
ORDER_CUSTOMER_ID=orders,order_customer_id,int
ORDER_STATUS=orders,order_status,string
ORDER_PRODUCT_ID=orders,order_product_id,int
ORDER_QUANTITY=orders,order_quantity,int
ORDER_SUBTOTAL=orders,order_subtotal,float
ORDER_PRODUCT_PRICE=orders,order_product_price,float

import java.util.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import org.apache.hadoop.hive.conf.HiveConf;
import org.apache.hadoop.hive.conf.HiveConf.ConfVars;

import org.apache.hadoop.fs.Path;

public class ReadHiveMetaDataJdbc {

	private static String driverName = "org.apache.hive.jdbc.HiveDriver";

	public static void main(String[] args) throws SQLException {
		try {
			Class.forName(driverName);
			HiveConf conf = new HiveConf();
			conf.addResource(new Path("file:////etc/hive/conf/hive-site.xml"));

			Class.forName(conf.getVar(ConfVars.METASTORE_CONNECTION_DRIVER));
			Connection conn = DriverManager.getConnection(
					conf.getVar(ConfVars.METASTORECONNECTURLKEY),
					conf.getVar(ConfVars.METASTORE_CONNECTION_USER_NAME),
					conf.getVar(ConfVars.METASTOREPWD));

			Statement st = conn.createStatement();
			ResultSet res = st.executeQuery("Select * from db_name.name_of_metadata_table");
			List<Metadata> metadata = new ArrayList<>();
			while (res.next()) {
				Metadata m = new Metadata();
				m.setTableName(res.getString("Table_Name"));
				m.setColumnName(res.getString("Column_Name"));
				m.setDataType(res.getString("Data_Type"));
				m.setPrimary("Y".equals(res.getString("Is_Primary")));
				metadata.add(m);
				System.out.println(m.toString());
			}

			conn.close();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.exit(1);
		}
	}
}