hive之建立的parquet外表，sparksql可读

方法一：
可以用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';