Hi,
Exploring Iceberg here. Trying a hello-world in java.
Am able to read and write to a table(“company”) on disk with Spark. However,
when I tried –
Dataset<Row> updated= spark.sql("SELECT * FROM iceberg.company where
date_updated != 0");
Got the following exception -
Caused by: org.apache.spark.sql.AnalysisException: Unsupported data source type
for direct query on files: iceberg;
at
org.apache.spark.sql.execution.datasources.ResolveSQLOnFile$$anonfun$apply$4.applyOrElse(rules.scala:56)
... 51 more
Is it not supported yet or I am doing it incorrectly?
I have been able to read the dataset and then filtering on it by using the
following (where Company is my POJO)
spark.read.format(“iceberg”).load(company.location()).as(Company.getEncoder());
Appreciate the help.
-Sandeep
The information contained in this email may be confidential. It has been sent
for the sole use of the intended recipient(s). If the reader of this email is
not an intended recipient, you are hereby notified that any unauthorized
review, use, disclosure, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this email in error,
please notify the sender immediately and destroy all copies of the message.