Skip to content

Jsonpath#24148

Merged
kssenii merged 49 commits intoClickHouse:masterfrom
l1tsolaiki:jsonpath
Jul 6, 2021
Merged

Jsonpath#24148
kssenii merged 49 commits intoClickHouse:masterfrom
l1tsolaiki:jsonpath

Conversation

@l1tsolaiki
Copy link
Copy Markdown
Contributor

I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en

Changelog category (leave one):

  • New Feature

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Adding support for a part of SQLJSON standard.

Detailed description / Documentation draft:

Adding support for a part of SQLJSON standard: jsonpath and functions.

By adding documentation, you'll allow users to try your new feature immediately, not when someone else will have time to document it later. Documentation is necessary for all features that affect user experience in any way. You can add brief documentation draft above, or add documentation right into your patch as Markdown files in docs folder.

If you are doing this for the first time, it's recommended to read the lightweight Contributing to ClickHouse Documentation guide first.

Information about CI checks: https://clickhouse.tech/docs/en/development/continuous-integration/

ltybc-coder and others added 3 commits February 3, 2021 15:11
Just works (remastered)

First steps

First steps fixed

First steps first fails

Research first steps

Tokenizer created

Sprint to the moon

Rename

Rename 2.0

Rename 3.0

Work in progress

Update

Oops

Oops x2

Try this

Now surely works

Maybe now?

Now?

Cmake first try

Restore to previous

Cmake second try

Make this work

Correct mistakes

Third try cmake

Exclude simd

Better

Try

Add std::cerr

More std::cerr

More and more std::cerr

Maybe fix?

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

AA

AB

AC

AD

AE

AF

AAA

AAB

AAC

AAD

AAF

AAE

AAF

AAG

AAH

AAI

AAJ

AAK

AAAA

AAAB

AAAC

AAAD

AAAE

AAAF

AAAG

AAAH

AAAAA

AAAAB

First try v2

First try v2.1

First try v2.2

First try v2.3

First try v2.4

First try v2.5

First try v2.6

First try v2.7

First try v2.8

First try v2.9

First try v2.10

First try v2.11

First try v2.12

First try v2.13

First try v2.14

First try v2.15

First try v2.16

First try v2.16

First try v2.17

First try v2.18

First try v2.19

First try v2.20

First try v2.21

First try v2.22

First try v2.23

First try v2.24

First try v2.25

First try v2.26

First try v2.27

First try v2.28

First try v2.29

First try v2.30

First try v2.31

First try v2.32

First try v2.33

First try v2.34

First try v2.35

First try v2.36

First try v2.37

Second try v2.00

Second try v2.01

Second try v2.02

Second try v2.03

Second try v2.04

Second try v2.05

Second try v2.06

Second try v2.07

Second try v2.08

Second try v2.09

Second try v2.10

Second try v2.11

Second try v2.12

Second try v2.13

Second try v2.14

Second try v2.15

Second try v2.16

Second try v2.17

Cleanup

Link SQLJSON only in simdjson build

Fix?

Fix?1.1

Fix

Revert "Fix"

This reverts commit 9df7aa977c880ec130062bceece7e215190b4837.

Revert "Fix?1.1"

This reverts commit 37429ecc9003fd73c106344186e39ff6603dde6c.

Revert "Fix?"

This reverts commit c1236fb8f4b5a799a5564aecf81136301f226e33.

Revert "Link SQLJSON only in simdjson build"

This reverts commit 8795cd8b143f3cfd312ddbf1b98e10d0d6fcaf51.

Revert "Cleanup"

This reverts commit e100dbc545f54421276be2e5d44f99f52fe1d87c.

Third try v2.0

Third try v2.1

Third try v2.2

Third try v2.3

Third try v2.4

Third try v2.5

Third try v2.6

Third try v2.7

Third try v2.8

Third try v2.9

Third try v2.10

Third try v2.11

Third try v2.12

Third try v2.13

Third try v2.14

Third try v2.15

Pre-intermediate touches v1.0

Pre-intermediate touches v1.1

Pre-intermediate touches v1.2

Pre-intermediate touches v1.3

Last changes
@robot-clickhouse robot-clickhouse added doc-alert pr-feature Pull request with new product feature labels May 15, 2021
Konstantin Rudenskii added 2 commits May 29, 2021 15:30
Fifth try v2.0

Fifth try v2.1

Fifth try v2.2

Fifth try v2.3

Fifth try v2.4

Fifth try v2.5

Fifth try v2.6

Fifth try v2.7

Fifth try v2.8

Fifth try v2.9

Fifth try v2.10

Fifth try v2.11

Fifth try v2.12

Fifth try v2.13

Fifth try v2.14

Fifth try v2.15

Fifth try v2.16

Fifth try v2.17

Fifth try v2.18

Fifth try v2.19

Fifth try v2.20

Fifth try v2.21

Fifth try v2.22

Fifth try v2.23

Fifth try v2.24

Fifth try v2.25

Fifth try v2.26

Fifth try v2.27

Fifth try v2.28

Add ranges

Add ranges try v1.1

Add ranges try v1.2

Add ranges try v1.3

Add ranges try v1.4

Add ranges try v1.5

Add ranges try v1.6

Add ranges try v1.7

Add ranges try v1.8

Add ranges try v1.9

Add ranges try v1.10

Add ranges try v1.11

Add ranges try v1.12

Add ranges try v1.13

Add ranges try v1.14

Add ranges try v1.15

Add ranges try v1.16

Add ranges try v1.17

Add ranges try v1.18

Add ranges try v1.19

Add ranges try v1.20

Add ranges try v1.21

Add ranges try v1.22

Add ranges try v1.23

Add ranges try v1.24

Add ranges try v1.25

Add ranges try v1.26

Add ranges try v1.27

Add ranges try v1.28

Add ranges try v1.29

Add ranges try v1.30

Add ranges try v1.31

Add ranges try v1.32

Add ranges try v1.33

Add ranges try v1.34

Add ranges try v1.35

Add ranges try v1.36

Add ranges try v1.37

Add ranges try v1.38

Add ranges try v1.39

Add ranges try v1.40

Add ranges try v1.41

Add ranges try v1.42

Add ranges try v1.43

Add ranges try v1.44

Add ranges try v1.45

Add ranges try v1.46

Add ranges try v1.47

Leftover comment

Try wildcard

Try wildcard v1.1

Try wildcard v1.2

Try wildcard v1.3

New functions

New functions 1.1

New functions 1.2

New functions 1.3

New functions 1.4

New functions 1.5

New functions 1.6

New functions 1.7

New functions 1.8

New functions 1.9

New functions 1.10

New functions 1.11

New functions 1.12

New functions 1.13

New functions 1.14

New functions 1.15

New functions 1.16

Final steps

Final steps v1.1

Final steps v1.2
@l1tsolaiki l1tsolaiki marked this pull request as ready for review May 29, 2021 12:42
Konstantin Rudenskii added 2 commits May 29, 2021 16:15
@kssenii kssenii self-assigned this May 31, 2021
Copy link
Copy Markdown
Member

@kssenii kssenii left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Also, please, merge with master, fix build and add tests.

@ClickHouse ClickHouse deleted a comment from l1tsolaiki Jun 6, 2021
@l1tsolaiki l1tsolaiki requested a review from kssenii June 25, 2021 16:27
@zifeo
Copy link
Copy Markdown

zifeo commented Jun 27, 2021

@l1tsolaiki will this feature be compatible with materialized views?

@l1tsolaiki
Copy link
Copy Markdown
Contributor Author

@l1tsolaiki will this feature be compatible with materialized views?

As far as I understand, it should work with materialized views.

@kssenii
Copy link
Copy Markdown
Member

kssenii commented Jul 6, 2021

Yandex synchronization check (only for Yandex employees) - E Exception: 01889_sql_json_functions: [ FAIL ] - return code 48 - fixed in master.
Integration tests - not related.
Functional stateless tests (release, wide parts enabled) — fail: - not related

@kssenii kssenii merged commit d2141ff into ClickHouse:master Jul 6, 2021
@gyuton
Copy link
Copy Markdown
Contributor

gyuton commented Jul 15, 2021

Internal documentation ticket: DOCSUP-11580.

@vkingnew
Copy link
Copy Markdown

vkingnew commented Sep 4, 2021

DOCSUP-11580
Could you have a url about SQL/json in clickhouse official docs?

@gyuton
Copy link
Copy Markdown
Contributor

gyuton commented Sep 4, 2021

@vkingnew Do you have a particular url in mind?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-feature Pull request with new product feature

Projects

None yet

Development

Successfully merging this pull request may close these issues.

7 participants