XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: core
    • Labels:
      None

      Description

      Complete JSON support for Calcite.

        Attachments

          Issue Links

          1.
          Implement SQL 2016 JSON functions Sub-task Closed Unassigned  
          2.
          JSON data type support Sub-task Open Unassigned  
          3.
          Add the JSON_DEPTH function Sub-task Closed Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 50m
          4.
          Add the JSON_TYPE function Sub-task Closed Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 3h 20m
          5.
          Add the JSON_PRETTY function Sub-task Closed Unassigned

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h 20m
          6.
          Add the JSON_LENGTH function Sub-task Closed Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 13h 20m
          7.
          Add the JSON_KEYS function Sub-task Closed Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 3h
          8.
          Implement JSON_INSERT, JSON_REPLACE, JSON_SET Sub-task Open Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 8h
          9.
          Implement JSON_TABLE table function Sub-task Open Forward Xu  
          10.
          Combine similar JSON aggregate functions in operator table Sub-task Closed Julian Hyde  
          11.
          Add order by clause support for JSON_ARRAYAGG Sub-task Closed Hongze Zhang

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 50m
          12.
          JSON aggregate calls with different null clause get incorrectly merged during converting from SQL to relational algebra Sub-task Closed Hongze Zhang

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          13.
          Support for JSON key uniqueness constraint Sub-task Open Unassigned  
          14.
          Support for JSON query quotes behavior Sub-task Open Ritesh

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h 20m
          15.
          Support for specifying encoding in JSON representation clause Sub-task Open Unassigned  
          16.
          Implement JSON_REMOVE function Sub-task Closed Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 3.5h
          17.
          Implement JSON_STORAGE_SIZE function Sub-task Closed Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 2h 40m
          18.
          In SQL parser, move JsonValueExpression into Expression Sub-task Closed Hongze Zhang

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          19.
          Improve null handling of JsonValueExpressionOperator Sub-task Closed Hongze Zhang

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1.5h
          20.
          Move MySQL's JSON operators to SqlLibraryOperators Sub-task Closed Hongze Zhang

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          21.
          Implement JSON_UNQUOTE, JSON_QUOTE function Sub-task Open Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h 40m
          22.
          Implement JSON_EXTRACT function Sub-task Open Forward Xu

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 2h

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                zhztheplayer Hongze Zhang
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 44h 20m
                  44h 20m