nsivabalan opened a new issue #3395: URL: https://github.com/apache/hudi/issues/3395
**_Tips before filing an issue_** - Have you gone through our [FAQs](https://cwiki.apache.org/confluence/display/HUDI/FAQ)? - Join the mailing list to engage in conversations and get faster support at [email protected]. - If you have triaged this as a bug, then file an [issue](https://issues.apache.org/jira/projects/HUDI/issues) directly. **Describe the problem you faced** A clear and concise description of the problem. I am an Architect in a reputable Product based IT firm. I am in the evaluation process to use Hudi to incorporate a refreshable data lake. I am currently running the setup in my local machine and using a spark datasource to write and read from the Hudi temp table. I have evaluated the Cow and MoR write mechanisms but while trying to read the Hudi table using Read_Optimized type I am getting the below exception: ``` Exception in thread "main" org.apache.hudi.exception.HoodieException: Invalid query type :read_optimized at org.apache.hudi.DefaultSource.createRelation(DefaultSource.scala:81) at org.apache.hudi.DefaultSource.createRelation(DefaultSource.scala:46) at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:332) at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:242) ``` Below is the how I am trying to read from the Hudi location: ``` spark.read .format("hudi") .option(DataSourceReadOptions.QUERY_TYPE_OPT_KEY, DataSourceReadOptions.QUERY_TYPE_READ_OPTIMIZED_OPT_VAL) .load(s"$basePath/$tableName") .show(50,false) ``` Kindly suggest if I am doing anything wrong? **To Reproduce** Steps to reproduce the behavior: 1. 2. 3. 4. **Expected behavior** A clear and concise description of what you expected to happen. **Environment Description** * Hudi version : 0.7.0 * Spark version : 2.4.7 * Hive version : * Hadoop version : * Storage (HDFS/S3/GCS..) : * Running on Docker? (yes/no) : scala 2.12 local **Additional context** Add any other context about the problem here. **Stacktrace** ```Add the stacktrace of the error.``` -- 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]
