native-sql-engine/.github/workflows/tpch.yml at master · rui-mo/native-sql-engine · GitHub

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
77
78
79
80
81
# 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.

name: Native SQL Engine TPC-H Suite

on:
  pull_request

jobs:
  ram-usage-test:
    if: ${{ contains(github.event.pull_request.labels.*.name, 'RAM Report') }}
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v2
      - name: Set up JDK 1.8
        uses: actions/setup-java@v1
        with:
          java-version: 1.8
      - uses: iterative/setup-cml@v1
        with:
          version: latest
      - run: sudo swapoff -a
      - run: free
      - run: sudo apt-get update
      - run: sudo apt-get install cmake
      - run: sudo apt-get install libboost-all-dev
      - name: Install OAP optimized Arrow
        run: |
          cd /tmp
          git clone https://github.com/oap-project/arrow.git
          cd arrow && git checkout arrow-3.0.0-oap && cd cpp
          mkdir build && cd build
          cmake .. -DARROW_JNI=ON -DARROW_GANDIVA_JAVA=ON -DARROW_GANDIVA=ON -DARROW_PARQUET=ON -DARROW_CSV=ON -DARROW_HDFS=ON -DARROW_FILESYSTEM=ON -DARROW_WITH_SNAPPY=ON -DARROW_JSON=ON -DARROW_DATASET=ON -DARROW_WITH_LZ4=ON -DARROW_JEMALLOC=OFF && make -j2
          sudo make install
          cd ../../java
          mvn clean install -B -Dorg.slf4j.simpleLogger.log.org.apache.maven.cli.transfer.Slf4jMavenTransferListener=warn -P arrow-jni -am -Darrow.cpp.build.dir=/tmp/arrow/cpp/build/release/ -DskipTests -Dcheckstyle.skip
      - name: Run Maven tests - BHJ
        run: |
          mvn test -B -pl native-sql-engine/core/ -am -Dorg.slf4j.simpleLogger.log.org.apache.maven.cli.transfer.Slf4jMavenTransferListener=warn -DmembersOnlySuites=com.intel.oap.tpc.h -DtagsToInclude=com.intel.oap.tags.BroadcastHashJoinMode -DargLine="-Xmx1G -XX:MaxDirectMemorySize=500M -Dio.netty.allocator.numDirectArena=1"
        env:
          MALLOC_ARENA_MAX: "4"
          MAVEN_OPTS: "-Xmx1G"
          COMMENT_TEXT_OUTPUT_PATH: "/tmp/comment_text_1.txt"
          COMMENT_IMAGE_OUTPUT_PATH: "/tmp/comment_image_1.png"
          ENABLE_TPCH_TESTS: "true"
      - name: Run Maven tests - SMJ
        run: |
          mvn test -B -pl native-sql-engine/core/ -am -Dorg.slf4j.simpleLogger.log.org.apache.maven.cli.transfer.Slf4jMavenTransferListener=warn -DmembersOnlySuites=com.intel.oap.tpc.h -DtagsToInclude=com.intel.oap.tags.SortMergeJoinMode -DargLine="-Xmx1G -XX:MaxDirectMemorySize=500M -Dio.netty.allocator.numDirectArena=1"
        env:
          MALLOC_ARENA_MAX: "4"
          MAVEN_OPTS: "-Xmx1G"
          COMMENT_TEXT_OUTPUT_PATH: "/tmp/comment_text_2.txt"
          COMMENT_IMAGE_OUTPUT_PATH: "/tmp/comment_image_2.png"
          ENABLE_TPCH_TESTS: "true"
      - run: |
          cml-publish /tmp/comment_image_1.png --md > /tmp/comment.md
          cml-publish /tmp/comment_image_2.png --md >> /tmp/comment.md
      - run: echo "::set-output name=event_path::${GITHUB_EVENT_PATH}"
        id: output-envs
      - uses: actions/upload-artifact@v2
        with:
          name: comment_content
          path: /tmp/comment.md
      - uses: actions/upload-artifact@v2
        with:
          name: pr_event
          path: ${{steps.output-envs.outputs.event_path}}