doris icon indicating copy to clipboard operation
doris copied to clipboard

Published 20 hours ago • verified publisher icon apache

[feature](JSON datatype)Support JSON datatype

Open freesinger opened this issue 3 years ago • 4 comments

Proposed changes

Add JSON datatype, following features are implemented by this PR:

  1. CREATE tables with JSON type columns
  2. INSERT values containing JSON type value stored in String, which is represented as binary format(AKA JSONB) at BE
  3. SELECT JSON columns

Detail design refers DSIP-016: Support JSON type

Checklist(Required)

  1. Does it affect the original behavior: (Yes/No/I Don't know)
  2. Has unit tests been added: (Yes/No/No Need)
  3. Has document been added or modified: (Yes/No/No Need)
  4. Does it need to update dependencies: (Yes/No)
  5. Are there any changes that cannot be rolled back: (Yes/No)

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...

freesinger avatar Jun 21 '22 15:06 freesinger

Wonderful work

kpfly avatar Jun 22 '22 03:06 kpfly

No UT is included in this PR?

yep, I may add this later since this is really a heavy work

freesinger avatar Jun 22 '22 05:06 freesinger

Sample records are as follows: image

freesinger avatar Sep 08 '22 11:09 freesinger

LGTM

xiaokang avatar Sep 20 '22 15:09 xiaokang

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

github-actions[bot] avatar Sep 25 '22 05:09 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Sep 25 '22 05:09 github-actions[bot]

Thanks for @xiaokang 's carefully review and tremendous aid. Cheers~

freesinger avatar Sep 25 '22 06:09 freesinger