private static HiveTableDefinition allHiveSimpleTypesParquetTableDefinition() {
String tableName = "parquet_all_types";
HiveDataSource dataSource =
createResourceDataSource(
tableName,
"" + System.currentTimeMillis(),
"com/facebook/presto/tests/hive/data/all_types/data.parquet");
return HiveTableDefinition.builder()
.setName(tableName)
.setCreateTableDDLTemplate(
""
+ "CREATE EXTERNAL TABLE %NAME%("
+ " c_tinyint TINYINT,"
+ " c_smallint SMALLINT,"
+ " c_int INT,"
+ " c_bigint BIGINT,"
+ " c_float FLOAT,"
+ " c_double DOUBLE,"
+ " c_timestamp TIMESTAMP,"
+ " c_string STRING,"
+ " c_varchar VARCHAR(10),"
+ " c_char CHAR(10),"
+ " c_boolean BOOLEAN"
+ ") "
+ "STORED AS PARQUET "
+ "LOCATION '%LOCATION%'")
.setDataSource(dataSource)
.build();
}
private static HiveTableDefinition allHiveSimpleTypesKnownToPrestoTextfileTableDefinition() {
String tableName = "textfile_all_types_known_to_presto";
HiveDataSource dataSource =
createResourceDataSource(
tableName,
"" + System.currentTimeMillis(),
"com/facebook/presto/tests/hive/data/all_types_known_to_presto/data.textfile");
return HiveTableDefinition.builder()
.setName(tableName)
.setCreateTableDDLTemplate(
""
+ "CREATE EXTERNAL TABLE %NAME%("
+ " c_tinyint TINYINT,"
+ " c_smallint SMALLINT,"
+ " c_int INT,"
+ " c_bigint BIGINT,"
+ " c_float FLOAT,"
+ " c_double DOUBLE,"
+ " c_timestamp TIMESTAMP,"
+ " c_date DATE,"
+ " c_string STRING,"
+ " c_varchar VARCHAR(10),"
+ " c_char CHAR(10),"
+ " c_boolean BOOLEAN,"
+ " c_binary BINARY"
+ ") "
+ "ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' "
+ "STORED AS TEXTFILE "
+ "LOCATION '%LOCATION%'")
.setDataSource(dataSource)
.build();
}
private static HiveTableDefinition allHiveSimpleTypesTableDefinition(
String fileFormat, Optional<String> rowFormat) {
String tableName = fileFormat.toLowerCase() + "_all_types";
HiveDataSource dataSource =
createResourceDataSource(
tableName,
"" + System.currentTimeMillis(),
"com/facebook/presto/tests/hive/data/all_types/data." + fileFormat.toLowerCase());
return HiveTableDefinition.builder()
.setName(tableName)
.setCreateTableDDLTemplate(
""
+ "CREATE EXTERNAL TABLE %NAME%("
+ " c_tinyint TINYINT,"
+ " c_smallint SMALLINT,"
+ " c_int INT,"
+ " c_bigint BIGINT,"
+ " c_float FLOAT,"
+ " c_double DOUBLE,"
+ " c_decimal DECIMAL,"
+ " c_decimal_w_params DECIMAL(10,5),"
+ " c_timestamp TIMESTAMP,"
+ " c_date DATE,"
+ " c_string STRING,"
+ " c_varchar VARCHAR(10),"
+ " c_char CHAR(10),"
+ " c_boolean BOOLEAN,"
+ " c_binary BINARY"
+ ") "
+ (rowFormat.isPresent() ? "ROW FORMAT " + rowFormat.get() + " " : " ")
+ "STORED AS "
+ fileFormat
+ " "
+ "LOCATION '%LOCATION%'")
.setDataSource(dataSource)
.build();
}