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/05/19 09:40:52 UTC

[GitHub] [hudi] eric9204 opened a new issue, #5634: [SUPPORT]

eric9204 opened a new issue, #5634:
URL: https://github.com/apache/hudi/issues/5634

**_Tips before filing an issue_**

- Have you gone through our [FAQs](https://hudi.apache.org/learn/faq/)?
no
- 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.
2.
3.
4.

**Expected behavior**

A clear and concise description of what you expected to happen.
problem 1:flink sql pull data from kafka and write to hudi,there are 11000 records in kafka topic,10000 records are inserts and other 1000 records are updates,enable index global config upsert write operation,select count hudi target table ,there are 10818 records in hudi target table.it seems like upsert operation did not work.
problem 2: the last deltacommit did not commit up to now.
**Environment Description**

* Hudi version :
0.11.0
* Spark version :
--
* Hive version :
3.1.2
* Hadoop version :
3.3.0
* Storage (HDFS/S3/GCS..) :
hdfs
* Running on Docker? (yes/no) :
no
**Additional context**
flink1.14.4 & flink 1.13.5
Add any other context about the problem here.

**Stacktrace**

```Add the stacktrace of the error.```

![image](https://user-images.githubusercontent.com/90449228/169259825-899d134c-1a58-485e-be08-3ad36c772acb.png)
![image](https://user-images.githubusercontent.com/90449228/169259965-ee6299a4-54d7-40ca-ace4-6c7efd729901.png)
![image](https://user-images.githubusercontent.com/90449228/169262174-c7a8bafa-27fe-4226-b49c-1e8c8fd8f09b.png)
![image](https://user-images.githubusercontent.com/90449228/169262886-54138e19-ead9-452c-876c-33564b7ce6e9.png)
![image](https://user-images.githubusercontent.com/90449228/169262927-02f1bd1e-4b85-482d-a641-73411b326591.png)
![image](https://user-images.githubusercontent.com/90449228/169263167-26010eaa-cbdb-4c7b-bc60-ad9a30a15dfa.png)

--
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write opration seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1135393443

   Thank you for your reply！this time ,i Insert three batches of the same data（recordkey from 0 to 999）,then insert the last 10000 records(recordkey from 0 to 9999), all of  write operation is upsert and set index.global.enabled=true.
   
   theoretically,The target hudi table should have 10000 records. 
   
   ro table
   ![image](https://user-images.githubusercontent.com/90449228/169948161-e90bf76d-4f30-40aa-b621-ac13e9b5d77b.png)
   
   rt table
   ![image](https://user-images.githubusercontent.com/90449228/169948308-a354088e-8b58-4180-aebe-4bc08523e3e0.png)
   
   sql statement
   ![image](https://user-images.githubusercontent.com/90449228/169948606-02b55249-949c-4c8e-be8a-48a26be16a77.png)
   
   kafka data
   ![image](https://user-images.githubusercontent.com/90449228/169949133-d5609f92-bb6d-418c-bdc9-483ea6956d7b.png)
   
   
   
   


-- 
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] danny0405 commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

danny0405 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1149735848

   The bucket index has some bugs though, let'w wait for the 0.11.1 release.


-- 
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write opration seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1135360070

   when i set write.precombine = true,the NonPartitioned hudi table  have not duplicate record,but the Partitioned hudi table have duplicate record


-- 
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write opration seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1135326845

   this problem has been solved，so i will close this issue 


-- 
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] danny0405 commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

danny0405 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1149378788

   Did you query it using Flink instead ?


-- 
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 #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

nsivabalan commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1150486579

   thanks! if we have a tracking jira, can you link it here and close this one out. 


-- 
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] danny0405 commented on issue #5634: [SUPPORT] -- The UPSERT write opration seems did not WORK !

Posted by GitBox <gi...@apache.org>.

danny0405 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1135368132

   The `write.precombine` is default false for MOR table, and i see you query the rt table from hive side, this may be a bug in hive query, did you try the ro table though ?


-- 
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1150587198

   > thanks! if we have a tracking jira, can you link it here and close this one out.
   
   Yes, I will.


-- 
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] eric9204 closed issue #5634: [SUPPORT] -- The UPSERT write opration seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 closed issue #5634: [SUPPORT] -- The UPSERT write opration seems did  not WORK !
URL: https://github.com/apache/hudi/issues/5634


-- 
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] codope commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

codope commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1160580175

   @eric9204 v0.11.1 is released now. Can you please try again? If you still face the issue, please open a JIRA and share the ticket here.


-- 
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1149409252

   > Did you query it using Flink instead ?
   
   @danny0405 Yes, the query results are all consistent with presto, spark sql, flink sql and hive.


-- 
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 #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

nsivabalan commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1149246210

   @danny0405 : can you follow up on this please when you get a chance. 


-- 
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1161174801

   @codope This problem still exists，when i use v0.11.1 . I will close this issue and link a jira here.
    


-- 
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] eric9204 commented on issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 commented on issue #5634:
URL: https://github.com/apache/hudi/issues/5634#issuecomment-1161176030

   https://issues.apache.org/jira/projects/HUDI/issues/HUDI-4289?filter=allissues


-- 
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] eric9204 closed issue #5634: [SUPPORT] -- The UPSERT write operation seems did not WORK !

Posted by GitBox <gi...@apache.org>.

eric9204 closed issue #5634: [SUPPORT] -- The UPSERT write operation seems did  not WORK !
URL: https://github.com/apache/hudi/issues/5634


-- 
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