86645ad54a
### _Why are the changes needed?_ This PR upgrades Kyuubi playground components to latest versions, including Spark 3.3.1, Kyuubi 1.6.1-incubating, Iceberg 1.1.0, and reorganizes the files in catalog folders. The images has been uploaded to Docker Hub. ### _How was this patch tested?_ - [ ] Add some test cases that check the changes thoroughly including negative and positive cases if possible - [x] Add screenshots for manual tests if appropriate ``` cd docker/playground docker compose up -d ``` ``` docker exec -it kyuubi /opt/kyuubi/bin/beeline -u 'jdbc:hive2://0.0.0.0:10009/tpcds/tiny' ``` <img width="1416" alt="image" src="https://user-images.githubusercontent.com/26535726/204845474-b0dff173-d335-43bf-b61f-d8c34ee26ff8.png"> - [ ] [Run test](https://kyuubi.apache.org/docs/latest/develop_tools/testing.html#running-tests) locally before make a pull request Closes #3881 from pan3793/playground. Closes #3881 a3d42377 [Cheng Pan] Upgrade playground components to latest versions Authored-by: Cheng Pan <chengpan@apache.org> Signed-off-by: Cheng Pan <chengpan@apache.org>
62 lines
2.0 KiB
SQL
62 lines
2.0 KiB
SQL
-- 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.
|
|
--
|
|
|
|
SET tiny_schema=tpch.tiny;
|
|
|
|
CREATE DATABASE IF NOT EXISTS spark_catalog.tpch_tiny;
|
|
|
|
USE spark_catalog.tpch_tiny;
|
|
|
|
--
|
|
-- Name: customer; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS customer USING parquet AS SELECT * FROM ${tiny_schema}.customer;
|
|
|
|
--
|
|
-- Name: orders; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS orders USING parquet AS SELECT * FROM ${tiny_schema}.orders;
|
|
|
|
--
|
|
-- Name: lineitem; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS lineitem USING parquet AS SELECT * FROM ${tiny_schema}.lineitem;
|
|
|
|
--
|
|
-- Name: part; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS part USING parquet AS SELECT * FROM ${tiny_schema}.part;
|
|
|
|
--
|
|
-- Name: partsupp; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS partsupp USING parquet AS SELECT * FROM ${tiny_schema}.partsupp;
|
|
|
|
--
|
|
-- Name: supplier; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS supplier USING parquet AS SELECT * FROM ${tiny_schema}.supplier;
|
|
|
|
--
|
|
-- Name: nation; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS nation USING parquet AS SELECT * FROM ${tiny_schema}.nation;
|
|
|
|
--
|
|
-- Name: region; Type: TABLE; Tablespace:
|
|
--
|
|
CREATE TABLE IF NOT EXISTS region USING parquet AS SELECT * FROM ${tiny_schema}.region;
|