You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HowardQin (via GitHub)" <gi...@apache.org> on 2023/07/17 03:03:39 UTC

[GitHub] [doris] HowardQin opened a new pull request, #21859: [Improvement](sql) support create or replace view (#20131)

HowardQin opened a new pull request, #21859:
URL: https://github.com/apache/doris/pull/21859

   create or replace view is implemented by reusing alter view logic, 
   and IF NOT EXISTS is not allowed with create or replace view.
   
   ## Proposed changes
   
   Issue Number: #20131 
   
   ## Further comments
   
   If the view already exists, follow alter view logic,
   otherwise follow create view logic。
   
   


-- 
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: [PR] [Improvement](sql) support create or replace view (#20131) [doris]

Posted by "HowardQin (via GitHub)" <gi...@apache.org>.
HowardQin closed pull request #21859: [Improvement](sql) support create or replace view (#20131)
URL: https://github.com/apache/doris/pull/21859


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


[GitHub] [doris] hello-stephen commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1647136747

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.36 seconds
    stream load tsv:          510 seconds loaded 74807831229 Bytes, about 139 MB/s
    stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          29.3 seconds inserted 10000000 Rows, about 341K ops/s
    storage size: 17160875327 Bytes


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


[GitHub] [doris] morningman commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1642092686

   run buildall


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


[GitHub] [doris] HowardQin commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "HowardQin (via GitHub)" <gi...@apache.org>.
HowardQin commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1647112131

   run buildall


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


[GitHub] [doris] github-actions[bot] commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1642094177

   PR approved by at least one committer and no changes requested.


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


[GitHub] [doris] github-actions[bot] commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1642094248

   PR approved by anyone and no changes requested.


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


[GitHub] [doris] hello-stephen commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1642180569

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 53.52 seconds
    stream load tsv:          500 seconds loaded 74807831229 Bytes, about 142 MB/s
    stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          29.0 seconds inserted 10000000 Rows, about 344K ops/s
    storage size: 17168440075 Bytes


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


[GitHub] [doris] HowardQin commented on pull request #21859: [Improvement](sql) support create or replace view (#20131)

Posted by "HowardQin (via GitHub)" <gi...@apache.org>.
HowardQin commented on PR #21859:
URL: https://github.com/apache/doris/pull/21859#issuecomment-1647118019

   > run buildall
   
   Hi, can you trigger this again?


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