Java tutorial
/** * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ package org.apache.hive.hcatalog.mapreduce; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertTrue; import java.io.File; import java.io.IOException; import java.util.ArrayList; import java.util.Iterator; import org.apache.commons.io.FileUtils; import org.apache.hadoop.conf.Configuration; import org.apache.hadoop.hive.cli.CliSessionState; import org.apache.hadoop.hive.conf.HiveConf; import org.apache.hadoop.hive.metastore.MetaStoreUtils; import org.apache.hadoop.hive.ql.Driver; import org.apache.hadoop.hive.ql.session.SessionState; import org.apache.hadoop.io.LongWritable; import org.apache.hadoop.io.NullWritable; import org.apache.hadoop.io.Text; import org.apache.hadoop.mapreduce.Job; import org.apache.hadoop.mapreduce.Mapper; import org.apache.hadoop.mapreduce.lib.input.TextInputFormat; import org.apache.hive.hcatalog.HcatTestUtils; import org.apache.hive.hcatalog.common.HCatConstants; import org.apache.hive.hcatalog.common.HCatException; import org.apache.hive.hcatalog.common.HCatUtil; import org.apache.hive.hcatalog.data.DefaultHCatRecord; import org.apache.hive.hcatalog.data.schema.HCatFieldSchema; import org.apache.hive.hcatalog.data.schema.HCatSchema; import org.apache.pig.ExecType; import org.apache.pig.PigServer; import org.apache.pig.data.Tuple; import org.junit.After; import org.junit.Before; import org.junit.Test; public class TestSequenceFileReadWrite { private File dataDir; private String warehouseDir; private String inputFileName; private Driver driver; private PigServer server; private String[] input; private HiveConf hiveConf; @Before public void setup() throws Exception { dataDir = new File(System.getProperty("java.io.tmpdir") + File.separator + TestSequenceFileReadWrite.class.getCanonicalName() + "-" + System.currentTimeMillis()); hiveConf = new HiveConf(this.getClass()); warehouseDir = HCatUtil.makePathASafeFileName(dataDir + File.separator + "warehouse"); inputFileName = HCatUtil.makePathASafeFileName(dataDir + File.separator + "input.data"); hiveConf = new HiveConf(this.getClass()); hiveConf.set(HiveConf.ConfVars.PREEXECHOOKS.varname, ""); hiveConf.set(HiveConf.ConfVars.POSTEXECHOOKS.varname, ""); hiveConf.set(HiveConf.ConfVars.HIVE_SUPPORT_CONCURRENCY.varname, "false"); hiveConf.set(HiveConf.ConfVars.METASTOREWAREHOUSE.varname, warehouseDir); hiveConf.setVar(HiveConf.ConfVars.HIVE_AUTHORIZATION_MANAGER, "org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory"); driver = new Driver(hiveConf); SessionState.start(new CliSessionState(hiveConf)); if (!(new File(warehouseDir).mkdirs())) { throw new RuntimeException("Could not create " + warehouseDir); } int numRows = 3; input = new String[numRows]; for (int i = 0; i < numRows; i++) { String col1 = "a" + i; String col2 = "b" + i; input[i] = i + "," + col1 + "," + col2; } HcatTestUtils.createTestDataFile(inputFileName, input); server = new PigServer(ExecType.LOCAL); } @After public void teardown() throws IOException { if (dataDir != null) { FileUtils.deleteDirectory(dataDir); } } @Test public void testSequenceTableWriteRead() throws Exception { String createTable = "CREATE TABLE demo_table(a0 int, a1 String, a2 String) STORED AS SEQUENCEFILE"; driver.run("drop table demo_table"); int retCode1 = driver.run(createTable).getResponseCode(); assertTrue(retCode1 == 0); server.setBatchOn(); server.registerQuery( "A = load '" + inputFileName + "' using PigStorage(',') as (a0:int,a1:chararray,a2:chararray);"); server.registerQuery("store A into 'demo_table' using org.apache.hive.hcatalog.pig.HCatStorer();"); server.executeBatch(); server.registerQuery("B = load 'demo_table' using org.apache.hive.hcatalog.pig.HCatLoader();"); Iterator<Tuple> XIter = server.openIterator("B"); int numTuplesRead = 0; while (XIter.hasNext()) { Tuple t = XIter.next(); assertEquals(3, t.size()); assertEquals(t.get(0).toString(), "" + numTuplesRead); assertEquals(t.get(1).toString(), "a" + numTuplesRead); assertEquals(t.get(2).toString(), "b" + numTuplesRead); numTuplesRead++; } assertEquals(input.length, numTuplesRead); } @Test public void testTextTableWriteRead() throws Exception { String createTable = "CREATE TABLE demo_table_1(a0 int, a1 String, a2 String) STORED AS TEXTFILE"; driver.run("drop table demo_table_1"); int retCode1 = driver.run(createTable).getResponseCode(); assertTrue(retCode1 == 0); server.setBatchOn(); server.registerQuery( "A = load '" + inputFileName + "' using PigStorage(',') as (a0:int,a1:chararray,a2:chararray);"); server.registerQuery("store A into 'demo_table_1' using org.apache.hive.hcatalog.pig.HCatStorer();"); server.executeBatch(); server.registerQuery("B = load 'demo_table_1' using org.apache.hive.hcatalog.pig.HCatLoader();"); Iterator<Tuple> XIter = server.openIterator("B"); int numTuplesRead = 0; while (XIter.hasNext()) { Tuple t = XIter.next(); assertEquals(3, t.size()); assertEquals(t.get(0).toString(), "" + numTuplesRead); assertEquals(t.get(1).toString(), "a" + numTuplesRead); assertEquals(t.get(2).toString(), "b" + numTuplesRead); numTuplesRead++; } assertEquals(input.length, numTuplesRead); } @Test public void testSequenceTableWriteReadMR() throws Exception { String createTable = "CREATE TABLE demo_table_2(a0 int, a1 String, a2 String) STORED AS SEQUENCEFILE"; driver.run("drop table demo_table_2"); int retCode1 = driver.run(createTable).getResponseCode(); assertTrue(retCode1 == 0); Configuration conf = new Configuration(); conf.set(HCatConstants.HCAT_KEY_HIVE_CONF, HCatUtil.serialize(hiveConf.getAllProperties())); Job job = new Job(conf, "Write-hcat-seq-table"); job.setJarByClass(TestSequenceFileReadWrite.class); job.setMapperClass(Map.class); job.setOutputKeyClass(NullWritable.class); job.setOutputValueClass(DefaultHCatRecord.class); job.setInputFormatClass(TextInputFormat.class); TextInputFormat.setInputPaths(job, inputFileName); HCatOutputFormat.setOutput(job, OutputJobInfo.create(MetaStoreUtils.DEFAULT_DATABASE_NAME, "demo_table_2", null)); job.setOutputFormatClass(HCatOutputFormat.class); HCatOutputFormat.setSchema(job, getSchema()); job.setNumReduceTasks(0); assertTrue(job.waitForCompletion(true)); if (!HCatUtil.isHadoop23()) { new FileOutputCommitterContainer(job, null).commitJob(job); } assertTrue(job.isSuccessful()); server.setBatchOn(); server.registerQuery("C = load 'default.demo_table_2' using org.apache.hive.hcatalog.pig.HCatLoader();"); server.executeBatch(); Iterator<Tuple> XIter = server.openIterator("C"); int numTuplesRead = 0; while (XIter.hasNext()) { Tuple t = XIter.next(); assertEquals(3, t.size()); assertEquals(t.get(0).toString(), "" + numTuplesRead); assertEquals(t.get(1).toString(), "a" + numTuplesRead); assertEquals(t.get(2).toString(), "b" + numTuplesRead); numTuplesRead++; } assertEquals(input.length, numTuplesRead); } @Test public void testTextTableWriteReadMR() throws Exception { String createTable = "CREATE TABLE demo_table_3(a0 int, a1 String, a2 String) STORED AS TEXTFILE"; driver.run("drop table demo_table_3"); int retCode1 = driver.run(createTable).getResponseCode(); assertTrue(retCode1 == 0); Configuration conf = new Configuration(); conf.set(HCatConstants.HCAT_KEY_HIVE_CONF, HCatUtil.serialize(hiveConf.getAllProperties())); Job job = new Job(conf, "Write-hcat-text-table"); job.setJarByClass(TestSequenceFileReadWrite.class); job.setMapperClass(Map.class); job.setOutputKeyClass(NullWritable.class); job.setOutputValueClass(DefaultHCatRecord.class); job.setInputFormatClass(TextInputFormat.class); job.setNumReduceTasks(0); TextInputFormat.setInputPaths(job, inputFileName); HCatOutputFormat.setOutput(job, OutputJobInfo.create(MetaStoreUtils.DEFAULT_DATABASE_NAME, "demo_table_3", null)); job.setOutputFormatClass(HCatOutputFormat.class); HCatOutputFormat.setSchema(job, getSchema()); assertTrue(job.waitForCompletion(true)); if (!HCatUtil.isHadoop23()) { new FileOutputCommitterContainer(job, null).commitJob(job); } assertTrue(job.isSuccessful()); server.setBatchOn(); server.registerQuery("D = load 'default.demo_table_3' using org.apache.hive.hcatalog.pig.HCatLoader();"); server.executeBatch(); Iterator<Tuple> XIter = server.openIterator("D"); int numTuplesRead = 0; while (XIter.hasNext()) { Tuple t = XIter.next(); assertEquals(3, t.size()); assertEquals(t.get(0).toString(), "" + numTuplesRead); assertEquals(t.get(1).toString(), "a" + numTuplesRead); assertEquals(t.get(2).toString(), "b" + numTuplesRead); numTuplesRead++; } assertEquals(input.length, numTuplesRead); } public static class Map extends Mapper<LongWritable, Text, NullWritable, DefaultHCatRecord> { public void map(LongWritable key, Text value, Context context) throws IOException, InterruptedException { String[] cols = value.toString().split(","); DefaultHCatRecord record = new DefaultHCatRecord(3); record.set(0, Integer.parseInt(cols[0])); record.set(1, cols[1]); record.set(2, cols[2]); context.write(NullWritable.get(), record); } } private HCatSchema getSchema() throws HCatException { HCatSchema schema = new HCatSchema(new ArrayList<HCatFieldSchema>()); schema.append(new HCatFieldSchema("a0", HCatFieldSchema.Type.INT, "")); schema.append(new HCatFieldSchema("a1", HCatFieldSchema.Type.STRING, "")); schema.append(new HCatFieldSchema("a2", HCatFieldSchema.Type.STRING, "")); return schema; } }