datafusion-dft 0.3.0

An opinionated and batteries included DataFusion implementation
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76

// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.

//! Tests for datafusion-function-json integration

use crate::extension_cases::TestExecution;

static TEST_TABLE: &str = r#"
CREATE TABLE test_table (
    id INT,
    json_col VARCHAR
) AS VALUES
(1, '{}'),
(2, '{ "a": 1 }'),
(3, '{ "a": 2 }'),
(4, '{ "a": 1, "b": 2 }'),
(5, '{ "a": 1, "b": 2, "c": 3 }')
"#;

/// Ensure one of the functions `json_contains` function is properly registered
#[tokio::test(flavor = "multi_thread")]
async fn test_basic() {
    let execution = TestExecution::new().await.with_setup(TEST_TABLE).await;

    let actual = execution
        .run_and_format("SELECT id, json_contains(json_col, 'b') as json_contains FROM test_table")
        .await;

    insta::assert_yaml_snapshot!(actual, @r###"
    - +----+---------------+
    - "| id | json_contains |"
    - +----+---------------+
    - "| 1  | false         |"
    - "| 2  | false         |"
    - "| 3  | false         |"
    - "| 4  | true          |"
    - "| 5  | true          |"
    - +----+---------------+
    "###);
}

/// ensure the json operators like -> are properly registered
#[tokio::test(flavor = "multi_thread")]
async fn test_operators() {
    let execution = TestExecution::new().await.with_setup(TEST_TABLE).await;

    let actual = execution
        .run_and_format("SELECT id, json_col->'a' as json_col_a FROM test_table")
        .await;

    insta::assert_yaml_snapshot!(actual, @r###"
    - +----+------------+
    - "| id | json_col_a |"
    - +----+------------+
    - "| 1  | {null=}    |"
    - "| 2  | {int=1}    |"
    - "| 3  | {int=2}    |"
    - "| 4  | {int=1}    |"
    - "| 5  | {int=1}    |"
    - +----+------------+
    "###);
}