feat(interactive): support extract intervals from temporal types in GIE #650
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: GraphScope GIE HighQPS DB CI | |
| on: | |
| # Trigger the workflow on push or pull request, | |
| # but only for the main branch | |
| workflow_dispatch: | |
| push: | |
| branches: | |
| - main | |
| paths: | |
| - 'flex/**' | |
| - 'interactive_engine/**' | |
| - '.github/workflows/hqps-db-ci.yml' | |
| pull_request: | |
| branches: | |
| - main | |
| paths: | |
| - 'flex/**' | |
| - 'interactive_engine/**' | |
| - '.github/workflows/hqps-db-ci.yml' | |
| concurrency: | |
| group: ${{ github.repository }}-${{ github.event.number || github.head_ref || github.sha }}-${{ github.workflow }} | |
| cancel-in-progress: true | |
| jobs: | |
| test-hqps-engine: | |
| runs-on: ubuntu-20.04 | |
| if: ${{ github.repository == 'alibaba/GraphScope' }} | |
| container: | |
| image: registry.cn-hongkong.aliyuncs.com/graphscope/hqps-server-base:v0.0.6 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - uses: actions/cache@v3 | |
| with: | |
| path: ~/.m2/repository | |
| key: ${{ runner.os }}-maven-${{ hashFiles('**/pom.xml') }} | |
| restore-keys: | | |
| ${{ runner.os }}-maven- | |
| - uses: actions/cache@v3 | |
| with: | |
| path: | | |
| ~/.cargo/bin/ | |
| ~/.cargo/registry/index/ | |
| ~/.cargo/registry/cache/ | |
| ~/.cargo/git/db/ | |
| ~/.cache/sccache | |
| key: ${{ runner.os }}-cargo-${{ hashFiles('**/Cargo.lock') }} | |
| - name: Install latest libgrape-lite | |
| if: false | |
| run: | | |
| git clone --single-branch https://github.com/alibaba/libgrape-lite.git /tmp/libgrape-lite | |
| cd /tmp/libgrape-lite | |
| mkdir -p build && cd build | |
| cmake .. | |
| make -j$(nproc) | |
| make install | |
| - name: Setup tmate session | |
| if: false | |
| uses: mxschmitt/action-tmate@v3 | |
| - name: Build | |
| env: | |
| GIE_HOME: ${{ github.workspace }}/interactive_engine/ | |
| HOME: /home/graphscope/ | |
| run: | | |
| cd ${GITHUB_WORKSPACE}/flex | |
| mkdir build && cd build | |
| cmake .. && sudo make -j$(nproc) | |
| sudo make install | |
| # cargo | |
| . /home/graphscope/.cargo/env | |
| which cargo | |
| # build compiler | |
| cd ${GIE_HOME}/compiler | |
| make build | |
| - name: Prepare dataset and workspace | |
| env: | |
| GS_TEST_DIR: ${{ github.workspace }}/gstest | |
| INTERACTIVE_WORKSPACE: /tmp/interactive_workspace | |
| run: | | |
| # download dataset | |
| git clone -b master --single-branch --depth=1 https://github.com/GraphScope/gstest.git ${GS_TEST_DIR} | |
| mkdir -p ${INTERACTIVE_WORKSPACE}/data/ldbc | |
| GRAPH_SCHEMA_YAML=${GS_TEST_DIR}/flex/ldbc-sf01-long-date/audit_graph_schema.yaml | |
| cp ${GRAPH_SCHEMA_YAML} ${INTERACTIVE_WORKSPACE}/data/ldbc/graph.yaml | |
| - name: Sample Query test | |
| env: | |
| GS_TEST_DIR: ${{ github.workspace }}/gstest | |
| run: | | |
| cd ${GITHUB_WORKSPACE}/flex/build | |
| export FLEX_DATA_DIR=${GS_TEST_DIR}/flex/ldbc-sf01-long-date | |
| ./tests/hqps/query_test ${GS_TEST_DIR}/flex/ldbc-sf01-long-date/audit_graph_schema.yaml \ | |
| ${GS_TEST_DIR}/flex/ldbc-sf01-long-date/audit_bulk_load.yaml \ | |
| /tmp/csr-data-dir/ | |
| - name: Run codegen test. | |
| env: | |
| GS_TEST_DIR: ${{ github.workspace }}/gstest | |
| HOME : /home/graphscope/ | |
| INTERACTIVE_WORKSPACE: /tmp/interactive_workspace | |
| run: | | |
| GIE_HOME=${GITHUB_WORKSPACE}/interactive_engine | |
| cd ${GITHUB_WORKSPACE}/flex/bin | |
| for i in 1 2 3 4 5 6 7 8 9 10 11 12; | |
| do | |
| cmd="./load_plan_and_gen.sh -e=hqps -i=../resources/queries/ic/adhoc/ic${i}_adhoc.cypher -w=/tmp/codgen/" | |
| cmd=${cmd}" -o=/tmp/plugin --ir_conf=${GS_TEST_DIR}/flex/ldbc-sf01-long-date/engine_config.yaml " | |
| cmd=${cmd}" --graph_schema_path=${INTERACTIVE_WORKSPACE}/data/ldbc/graph.yaml" | |
| echo $cmd | |
| eval ${cmd} | |
| done | |
| for i in 1 2 3 4 5 6 7 8 9; | |
| do | |
| cmd="./load_plan_and_gen.sh -e=hqps -i=../resources/queries/ic/adhoc/simple_match_${i}.cypher -w=/tmp/codgen/" | |
| cmd=${cmd}" -o=/tmp/plugin --ir_conf=${GS_TEST_DIR}/flex/ldbc-sf01-long-date/engine_config.yaml " | |
| cmd=${cmd}" --graph_schema_path=${INTERACTIVE_WORKSPACE}/data/ldbc/graph.yaml" | |
| echo $cmd | |
| eval ${cmd} | |
| done | |
| - name: Run End-to-End cypher adhoc query test | |
| env: | |
| GS_TEST_DIR: ${{ github.workspace }}/gstest | |
| HOME : /home/graphscope/ | |
| INTERACTIVE_WORKSPACE: /tmp/interactive_workspace | |
| run: | | |
| cd ${GITHUB_WORKSPACE}/flex/tests/hqps/ | |
| export FLEX_DATA_DIR=${GS_TEST_DIR}/flex/ldbc-sf01-long-date | |
| export ENGINE_TYPE=hiactor | |
| bash hqps_cypher_test.sh ${GS_TEST_DIR} ${INTERACTIVE_WORKSPACE} | |