You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hudi.apache.org by GitBox <gi...@apache.org> on 2022/07/18 03:57:57 UTC
[GitHub] [hudi] txl2017 opened a new issue, #6128: [SUPPORT] spark-sql can't create hudi table
txl2017 opened a new issue, #6128:
URL: https://github.com/apache/hudi/issues/6128
**_Tips before filing an issue_**
- Have you gone through our [FAQs](https://hudi.apache.org/learn/faq/)?
- Join the mailing list to engage in conversations and get faster support at dev-subscribe@hudi.apache.org.
- 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.
**To Reproduce**
Steps to reproduce the behavior:
1.spark-sql --jars /home/hudi-spark3.1-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'
2.create table hudi_spark.hudi_cow_nonpcf_tb1 (
uuid int,
name string,
price double
) using hudi;
3.22/07/18 11:32:53 WARN config.DFSPropertiesConfiguration: Cannot find HUDI_CONF_DIR, please set it as the dir of hudi-defaults.conf
22/07/18 11:32:53 WARN config.DFSPropertiesConfiguration: Properties file file:/etc/hudi/conf/hudi-defaults.conf not found. Ignoring to load props file
22/07/18 11:32:55 WARN command.CreateHoodieTableCommand: Failed to create catalog table in metastore: org.apache.hudi.hadoop.HoodieParquetInputFormat
Time taken: 2.437 seconds
4.show tables;
no table created.
the folder /user/hive/warehouse/hudi_spark.db/hudi_cow_nonpcf_tb1 created success
**Expected behavior**
A clear and concise description of what you expected to happen.
**Environment Description**
* Hudi version :
0.11.1
* Spark version :
3.1.2
* Hive version :
2.1.1
* Hadoop version :
3.0.0
* Storage (HDFS/S3/GCS..) :
HDFS
* Running on Docker? (yes/no) :
no
**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: commits-unsubscribe@hudi.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hudi] ashokblend commented on issue #6128: [SUPPORT] spark-sql can't create hudi table
Posted by GitBox <gi...@apache.org>.
ashokblend commented on issue #6128:
URL: https://github.com/apache/hudi/issues/6128#issuecomment-1253178312
after adding hudi-hadoop-mr-bundle-0.10.1.jar to hiverserver lib, it works.
--
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: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hudi] xushiyan closed issue #6128: [SUPPORT] spark-sql can't create hudi table
Posted by GitBox <gi...@apache.org>.
xushiyan closed issue #6128: [SUPPORT] spark-sql can't create hudi table
URL: https://github.com/apache/hudi/issues/6128
--
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: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hudi] nsivabalan commented on issue #6128: [SUPPORT] spark-sql can't create hudi table
Posted by GitBox <gi...@apache.org>.
nsivabalan commented on issue #6128:
URL: https://github.com/apache/hudi/issues/6128#issuecomment-1229345579
yes, ensure you use hive2.3+ and you have hive sync configs properly configured.
--
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: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hudi] xushiyan commented on issue #6128: [SUPPORT] spark-sql can't create hudi table
Posted by GitBox <gi...@apache.org>.
xushiyan commented on issue #6128:
URL: https://github.com/apache/hudi/issues/6128#issuecomment-1188590383
@txl2017 suspect sth to do with your hive version. can you try hive 2.3.x ?
--
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: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hudi] xushiyan commented on issue #6128: [SUPPORT] spark-sql can't create hudi table
Posted by GitBox <gi...@apache.org>.
xushiyan commented on issue #6128:
URL: https://github.com/apache/hudi/issues/6128#issuecomment-1296115852
> after adding hudi-hadoop-mr-bundle-0.10.1.jar to hiverserver lib, it works.
Thanks for confirming.
--
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: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hudi] ashokblend commented on issue #6128: [SUPPORT] spark-sql can't create hudi table
Posted by GitBox <gi...@apache.org>.
ashokblend commented on issue #6128:
URL: https://github.com/apache/hudi/issues/6128#issuecomment-1251993575
@nsivabalan we are also facing same issue. Our use case is similar as mentioned in this ticket i.e
a. create hudi table(it should get registered to hive metastore)
b. insert data into hudi table using "insert into.." command.
I referred to below documentation but it doesn't help
https://hudi.apache.org/docs/next/syncing_metastore#spark-datasource-example
please share the documentation which states how to enable hive sync when create table using hudi command is executed in either spark-shell or spark-sql
Note: I am using hudi 0.10.1
--
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: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org