search

questdb / roadmap

QuestDB Public Roadmap
6 stars 0 forks source link

Support for updates #7

Closed bluestreak01 closed 2 years ago

bluestreak01 commented 2 years ago

Summary

We aim to support updates in use-cases where heavy data-acquisition is still the king, but occasional data corrections are still required. Users will be able leverage update SQL syntax in read-consistent context. delete operations are out of scope of this issue.

Expected outcome

The following syntax will be supported

[ WITH with_query [, ...] ]
UPDATE table_name [ [ AS ] alias ]
    SET { column_name = { expression } |
          ( column_name [, ...] ) = ( { expression } [, ...] ) |
          ( column_name [, ...] ) = ( sub-SELECT )
        } [, ...]
    [ FROM from_item [, ...] ]
    [ WHERE condition ]

This issue depends on #9

Shivansh-Mittal commented 2 years ago

Did update query support in questdb implemented ? Can i use update query now in questdb ? Kindly help by answering if you know.