Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-2868 Support TTL in kudu
  3. KUDU-2909

Implement DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP for kudu

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Implement DEAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP just like in MYSQL. 
      Here is the reference.
      https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html

      This feature can be helpful when user want an automatic timestamp column and
      can be used for further TTL.

      It works like this:
      1. Whether DEFAULT CURRENT_TIMESTAMP is set or ON UPDATE CURRENT_TIMESTAMP is set, will create a timestamp column for table.
      2. If only DEFAULT CURRENT_TIMESTAMP is set, then will get kudu time when insert.
      3. If only ON UPDATE CURRENT_TIMESTAMP is set, then it will have default value and will update timestamp column when update.
      4. If both set, then it will get kudu time when insert and update timestamp when update.

      Attachments

        Issue Links

          Activity

            People

              ZhangYao ZhangYao
              ZhangYao ZhangYao
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: