XMLWordPrintableJSON

Details

    • Task
    • Status: In Progress
    • Major
    • Resolution: Unresolved
    • None
    • None
    • core
    • 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 - 1.5h
          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

              Unassigned Unassigned
              zhztheplayer Hongze Zhang
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 44.5h
                  44.5h