You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hudi.apache.org by "screamedddd (via GitHub)" <gi...@apache.org> on 2024/10/24 11:50:47 UTC
[I] [SUPPORT] use flinksql write hudi0.15 timestamp(3), use sql-client for hive catalog search timestamp(9),why? [hudi]
screamedddd opened a new issue, #12156:
URL: https://github.com/apache/hudi/issues/12156
flinksql api execute sql
CREATE TABLE hudi_table(
ts timestamp(3),
uuid VARCHAR(40) PRIMARY KEY NOT ENFORCED,
rider VARCHAR(20),
driver VARCHAR(20),
fare DOUBLE,
city VARCHAR(20)
)
PARTITIONED BY (`city`)
WITH (
'connector' = 'hudi',
'path' = 'file:///tmp/hudi_table',
'table.type' = 'MERGE_ON_READ',
'hive_sync.enabled' = 'true',
'hive_sync.db' = 'hudi',
'hive_sync.table' = 'hudi_table',
'hive_sync.jdbc_url' = '',
'hive_sync.metastore.uris' = '',
'hive_sync.mode' = 'hms'
);
after insert into data, hive db=hudi has three tables, hudi_table_ro and hudi_table_rt and hudi_table
this is a question:
three tables column ts type is timestamp(9) , why?
--
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
Re: [I] [SUPPORT] use flinksql write hudi0.15 timestamp(3), use sql-client for hive catalog search timestamp(9),why? [hudi]
Posted by "danny0405 (via GitHub)" <gi...@apache.org>.
danny0405 commented on issue #12156:
URL: https://github.com/apache/hudi/issues/12156#issuecomment-2436626099
Hive does not support timestamp precision yet, did you use the Hudi hive catalog then?
--
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
Re: [I] [SUPPORT] use flinksql write hudi0.15 timestamp(3), use sql-client for hive catalog search timestamp(9),why? [hudi]
Posted by "screamedddd (via GitHub)" <gi...@apache.org>.
screamedddd closed issue #12156: [SUPPORT] use flinksql write hudi0.15 timestamp(3), use sql-client for hive catalog search timestamp(9),why?
URL: https://github.com/apache/hudi/issues/12156
--
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
Re: [I] [SUPPORT] use flinksql write hudi0.15 timestamp(3), use sql-client for hive catalog search timestamp(9),why? [hudi]
Posted by "screamedddd (via GitHub)" <gi...@apache.org>.
screamedddd commented on issue #12156:
URL: https://github.com/apache/hudi/issues/12156#issuecomment-2447230503
> Hive does not support timestamp precision yet, did you use the Hudi hive catalog then?
yes, i have used hudi hive catalog.
sql-client.sh -i hudicatalog login flink shell has correct timestamp.
--
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
Re: [I] [SUPPORT] use flinksql write hudi0.15 timestamp(3), use sql-client for hive catalog search timestamp(9),why? [hudi]
Posted by "screamedddd (via GitHub)" <gi...@apache.org>.
screamedddd commented on issue #12156:
URL: https://github.com/apache/hudi/issues/12156#issuecomment-2447231199
> Hive does not support timestamp precision yet, did you use the Hudi hive catalog then?
thanks
--
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