You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2024/07/31 14:57:34 UTC
[I] [Feature] temporary table support [doris]
dataroaring opened a new issue, #38635:
URL: https://github.com/apache/doris/issues/38635
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Description
Temporary tables are used for storing intermediate results, performing data transformations, and aiding complex query operations.
Temporary tables are often session-specific, meaning they are only accessible within the session in which they were created. Other sessions cannot access these tables, ensuring data isolation and security. Once the session terminates, the temporary tables are deleted.
Implemetation:
- create drop sql support.
- session maintain in doris, which can be bond with ConnectionContext.
- name issues, because different session can create temporary tables with same name and there are different tables, we can create a id for a session, e.g. uuid and temporary table's name is t_${session_uuid}_name.
- for simplicity, we can mark a table as temporary, then others can only see its own temporary tables.
- backup should ignores temporary tables.
- ccr should also ignores temporary tables.
### Use case
_No response_
### Related issues
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Feature] temporary table support [doris]
Posted by "binarytom (via GitHub)" <gi...@apache.org>.
binarytom commented on issue #38635:
URL: https://github.com/apache/doris/issues/38635#issuecomment-2264581298
@dataroaring I wanna have a try. Could assign this to me.
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Feature] temporary table support [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on issue #38635:
URL: https://github.com/apache/doris/issues/38635#issuecomment-2689817477
https://github.com/apache/doris/pull/40680
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Feature] temporary table support [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed issue #38635: [Feature] temporary table support
URL: https://github.com/apache/doris/issues/38635
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org