ldocao commented on issue #6902:
URL: https://github.com/apache/iceberg/issues/6902#issuecomment-2778266348
Hi,
I'm also encountering the same issue while running on iceberg 1.5.2 locally
with pyspark 3.5.2
```
E pyspark.errors.exceptions.captured.ParseException:
E [PARSE_SYNTAX_ERROR] Syntax error at or near 'CREATE'.(line
1, pos 54)
E
E == SQL ==
E ALTER TABLE iceberg_test.nyc_taxi.fhvhv_trips_iceberg CREATE
TAG `2024-01-01` AS OF VERSION 8461765733328903298
```
Here is my setup (iceberg 1.5.2 with spark 3.5.2):
```python
WAREHOUSE_PATH = "./warehouse"
catalog = "test_iceberg"
spark_builder = (spark_builder
.config(f"spark.sql.catalog.{catalog}",
"org.apache.iceberg.spark.SparkCatalog")
.config(f"spark.sql.catalog.{catalog}.type", "hadoop")
.config(f"spark.sql.catalog.{catalog}.warehouse", WAREHOUSE_PATH)
.config(f"spark.jars.packages",
"org.apache.iceberg:iceberg-spark-runtime-3.5_2.12:1.5.2")
.config(f"spark.sql.catalog.{catalog}.default.write.metadata-flush-after-create",
"true")
)
spark = spark_builder.getOrCreate()
spark.sql(f"""
CREATE TABLE {full_name} (
hvfhs_license_num STRING,
dispatching_base_num STRING,
originating_base_num STRING,
...
)
USING iceberg;""")
#i write into iceberg here without error
spark.sql("ALTER TABLE iceberg_test.nyc_taxi.fhvhv_trips_iceberg CREATE TAG
`2024-01-01` AS OF VERSION 8461765733328903298") #raises [PARSE_SYNTAX_ERROR]
Syntax error at or near 'CREATE'.(line 1, pos 54)
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
