[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-886379874 There is some ten valid segment status. You can refer to the file `SegmentStatus.java`. Once we trigger the load and if the load will be success then segment status will be success. And when we trigger compaction, all the segments that will participate in compaction will be marked as `compacted`, and new segments after compaction will be marked as success. -- 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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-885396320 That won't be deleted automatically. Once the retention time will expire the subsequent clean file command will delete the directory. ![image](https://user-images.githubusercontent.com/32429250/126738463-a7a688e9-aacc-43be-9c78-4d317c0ff094.png) This is as per design. -- 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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-883917592 As I can see in the output of the show segment => segment status with id 0 and 1 is marked for delete. It means these segments are not valid. You can execute once `clean file command` to remove these unnecessary segments. In the delete command, you can give the segment id which status is either success. Something similar to `DELETE FROM table test_table WHERE SEGMENT.ID IN (2.3)` After executing this query your segment status will be `marked for delete`. You can remove all these(marked for delete, compacted) segments with clean files. Refer to this: https://github.com/apache/carbondata/blob/master/docs/clean-files.md you can use force option for clean or based on your requirement. -- 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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-883222462 Can you please share the details of where you are running these queries? Either it is hive-beeline or spark sql/beeline, etc. As these queries should not fail. Because in the case of spark we have many test cases where we run this query. Ideally, it should not be an 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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-882401423 -- 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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-883222462 Can you please share the details of where you are running these queries? Either it is hive-beeline or spark sql/beeline, etc. As these queries should not fail. Because in the case of spark we have many test cases where we run this query. Ideally, it should not be an 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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [carbondata] nihal0107 commented on issue #4173: DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN reported an error in benline
nihal0107 commented on issue #4173: URL: https://github.com/apache/carbondata/issues/4173#issuecomment-882401423 Hi, please remove the keyword `table` from the query. New query would be something like: `DELETE FROM TABLE default.test_table WHERE SEGMENT.ID IN (0,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: issues-unsubscr...@carbondata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org