Github user watermen commented on the pull request:
https://github.com/apache/spark/pull/7210#issuecomment-125805938
@liancheng There have been many tables with large data, and reload data
into new table will spend much time. So I use it like this:
```
CREATE TABLE t1 (key INT, value STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.lib.CombineTextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
LOCATION '/tmp/test.txt'
;
```
It works, and parquet works when `set
spark.sql.hive.convertMetastoreParquet=false`:
```
CREATE TABLE t2 (key INT, value STRING)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS
INPUTFORMAT
'org.apache.spark.sql.hive.parquet.CombineParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/tmp/parquet'
;
```
When `set spark.sql.hive.convertMetastoreParquet=true`, Can I only use
`coalesce`? I have another PR(https://github.com/apache/spark/pull/7536) about
`coalesce`, Do you mind to review it? Thanks for your help.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
