jonvex commented on issue #7354:
URL: https://github.com/apache/hudi/issues/7354#issuecomment-1339836424
Ok, I used spark 3.2.1 and Hudi 0.11.1 and did these steps:
Started spark-sql by running
```
$SPARK_HOME/bin/spark-sql \
--jars
$HUDI_HOME/packaging/hudi-spark-bundle/target/hudi-spark3.2-bundle_2.12-0.11.1.jar
\
--conf 'spark.serializer=org.apache.spark.serializer.KryoSerializer' \
--conf
'spark.sql.extensions=org.apache.spark.sql.hudi.HoodieSparkSessionExtension' \
--conf
'spark.sql.catalog.spark_catalog=org.apache.spark.sql.hudi.catalog.HoodieCatalog'
\
--conf 'spark.sql.catalogImplementation=in-memory'
```
Then I created a table doing
```
create table no_ts (
id int,
name string,
price double,
age int,
part string
) using hudi
tblproperties (
type = 'mor',
primaryKey = 'id',
preCombineField = 'price',
hoodie.datasource.meta.sync.enable = false,
hoodie.datasource.hive_sync.enable = false
)
partitioned by (part);
```
and inserted data with:
```
insert into no_ts select 1, 'a1', 100, 10, 'p1';
insert into no_ts select 2, 'a2', 200, 12, 'p2';
```
I then created a second table from that one by doing
```
create table copy_no_ts using hudi
options (
type = 'mor',
primaryKey = 'id',
preCombineField = 'price',
hoodie.datasource.meta.sync.enable = false,
hoodie.datasource.hive_sync.enable = false
)
partitioned by (part)
AS
SELECT *
FROM no_ts;
```
No exception occurred and I both tables contained the correct data when
queried.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
