方法一:
可以用spark sql读取该外表
create external table test_table_name (x STRING,y STRING,
z STRING )
comment '表的作用'
partitioned by (dayno string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS
INPUTFORMAT"org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat"
OUTPUTFORMAT"org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat"
LOCATION 'hdfs://***/file';
alter table test_table_name add partition(dayno=20200805) location 'hdfs://***/file/dayno=20200805'
方法二:sparksql读取失败,需要调试maven
create external table test_table_name (x STRING,y STRING,
z STRING
)
comment '表的作用'
partitioned by (dayno string)
ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe'
STORED AS
INPUTFORMAT "parquet.hive.DeprecatedParquetInputFormat"
OUTPUTFORMAT "parquet.hive.DeprecatedParquetOutputFormat"
LOCATION 'hdfs://***/file';
create external table test_table_name (x STRING,y STRING,
z STRING
)
comment '表的作用'
partitioned by (dayno string)
ROW FORMAT SERDE 'parquet.hive.serde.ParquetHiveSerDe'
STORED AS
INPUTFORMAT "org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat"
OUTPUTFORMAT "org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat"
LOCATION 'hdfs://***/file';