text: --
  -- Table src
  --
  DROP TABLE IF EXISTS src;
  
  CREATE TABLE src (key STRING COMMENT 'default', value STRING COMMENT 'default') STORED AS TEXTFILE;
  
  LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt" INTO TABLE src;
  
  --
  -- Table srcpart
  --
  DROP TABLE IF EXISTS srcpart;
  
  CREATE TABLE srcpart (key STRING COMMENT 'default', value STRING COMMENT 'default')
  PARTITIONED BY (ds STRING, hr STRING)
  STORED AS TEXTFILE;
  
  LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
  OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-08", hr="11");
  
  LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
  OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-08", hr="12");
  
  LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
  OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-09", hr="11");
  
  LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
  OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-09", hr="12");
  
  --
  -- Table part
  --
  drop table if exists part;
  
  CREATE TABLE part(
      p_partkey INT,
      p_name STRING,
      p_mfgr STRING,
      p_brand STRING,
      p_type STRING,
      p_size INT,
      p_container STRING,
      p_retailprice DOUBLE,
      p_comment STRING
  );
  
  LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
  