[
https://issues.apache.org/jira/browse/HUDI-2249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17390850#comment-17390850
]
sivabalan narayanan commented on HUDI-2249:
-------------------------------------------
actually this works for me. not sure if I missed something earlier when I ran
into this. Closing this for now.
> [SQL] Changing index type fails
> -------------------------------
>
> Key: HUDI-2249
> URL: https://issues.apache.org/jira/browse/HUDI-2249
> Project: Apache Hudi
> Issue Type: Sub-task
> Reporter: sivabalan narayanan
> Priority: Blocker
> Labels: release-blocker
>
> I tried to set a different index type and it failed.
>
> ```
> set hoodie.index.type = SIMPLE
>
> spark-sql> create table hudi_17Gb_ext1 using hudi location
> 's3a://siva-test-bucket-june-16/hudi_testing/gh_arch_dump/hudi_5/' options (
> > type = 'cow',
> > primaryKey = 'randomId',
> > preCombineField = 'date_col'
> > )
> > partitioned by (type) as select * from gh_17Gb_date_col;
> 21/07/29 04:24:23 ERROR SparkSQLDriver: Failed in [create table
> hudi_17Gb_ext1 using hudi location
> 's3a://siva-test-bucket-june-16/hudi_testing/gh_arch_dump/hudi_5/' options (
> type = 'cow',
> primaryKey = 'randomId',
> preCombineField = 'date_col'
> )
> partitioned by (type) as select * from gh_17Gb_date_col]
> java.lang.IllegalArgumentException: No enum constant
> org.apache.hudi.index.HoodieIndex.IndexType.SIMPLE
>
>
> describe hudi_17Gb_ext
> at java.lang.Enum.valueOf(Enum.java:238)
> at org.apache.hudi.index.HoodieIndex$IndexType.valueOf(HoodieIndex.java:106)
> at
> org.apache.hudi.config.HoodieIndexConfig$Builder.build(HoodieIndexConfig.java:333)
> at
> org.apache.hudi.config.HoodieWriteConfig$Builder.setDefaults(HoodieWriteConfig.java:1608)
> at
> org.apache.hudi.config.HoodieWriteConfig$Builder.build(HoodieWriteConfig.java:1650)
> at
> org.apache.hudi.DataSourceUtils.createHoodieConfig(DataSourceUtils.java:196)
> at
> org.apache.hudi.DataSourceUtils.createHoodieClient(DataSourceUtils.java:201)
> at
> org.apache.hudi.HoodieSparkSqlWriter$.$anonfun$write$5(HoodieSparkSqlWriter.scala:183)
> at scala.Option.getOrElse(Option.scala:189)
> at
> org.apache.hudi.HoodieSparkSqlWriter$.write(HoodieSparkSqlWriter.scala:182)
> at
> org.apache.spark.sql.hudi.command.InsertIntoHoodieTableCommand$.run(InsertIntoHoodieTableCommand.scala:97)
> at
> org.apache.spark.sql.hudi.command.CreateHoodieTableAsSelectCommand.run(CreateHoodieTableAsSelectCommand.scala:86)
> at
> org.apache.spark.sql.execution.command.DataWritingCommandExec.sideEffectResult$lzycompute(commands.scala:108)
> at
> org.apache.spark.sql.execution.command.DataWritingCommandExec.sideEffectResult(commands.scala:106)
> at
> org.apache.spark.sql.execution.command.DataWritingCommandExec.executeCollect(commands.scala:120)
> at org.apache.spark.sql.Dataset.$anonfun$logicalPlan$1(Dataset.scala:229)
> at org.apache.spark.sql.Dataset.$anonfun$withAction$1(Dataset.scala:3618)
> at
> org.apache.spark.sql.execution.SQLExecution$.$anonfun$withNewExecutionId$5(SQLExecution.scala:100)
> at
> org.apache.spark.sql.execution.SQLExecution$.withSQLConfPropagated(SQLExecution.scala:160)
> at
> org.apache.spark.sql.execution.SQLExecution$.$anonfun$withNewExecutionId$1(SQLExecution.scala:87)
> at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:764)
> at
> org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:64)
> at org.apache.spark.sql.Dataset.withAction(Dataset.scala:3616)
> at org.apache.spark.sql.Dataset.<init>(Dataset.scala:229)
> at org.apache.spark.sql.Dataset$.$anonfun$ofRows$2(Dataset.scala:100)
> at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:764)
> at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:97)
> at org.apache.spark.sql.SparkSession.$anonfun$sql$1(SparkSession.scala:607)
> at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:764)
> at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:602)
> at org.apache.spark.sql.SQLContext.sql(SQLContext.scala:650)
> at
> org.apache.spark.sql.hive.thriftserver.SparkSQLDriver.run(SparkSQLDriver.scala:63)
> at
> org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.processCmd(SparkSQLCLIDriver.scala:377)
> at
> org.apache.spark.sql.hive.thriftserver.SparkSQLCLIDriver.$anonfun$processLine$1(SparkSQLCLIDriver.scala:496)
> ```
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
