Skip to content

[Bug]: ERROR 1146 (42S02) at line 1: Table 'TEST.LINEITEM' doesn't exist in obd tpch test #160

@longdafeng

Description

@longdafeng

Check Before Asking

  • Please check the issue list and confirm this bug is encountered for the first time.
  • Please try full text in English and attach precise description.

Environment

Failed to run obd tpch test

Fast Reproduce Steps

  1. create database cluster
  2. create tenant
obd cluster tenant create default -n test
  1. run tpch test
obd test tpch default -s 10 --remote-tbl-dir=/tmp/tpch  --database=tpch --disable-transfer
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect observer(server1(172.30.199.244):2881) ok
Optimize for stage test ok
Format DDL ok
Create table ok
Load data ok
Merge x
[ERROR] ERROR 1146 (42S02) at line 1: Table 'TEST.LINEITEM' doesn't exist

Actual Behavior

check the database

obclient [tpch]> show tables;
+----------------+
| Tables_in_tpch |
+----------------+
| customer       |
| lineitem       |
| nation         |
| orders         |
| part           |
| partsupp       |
| region         |
| supplier       |
+----------------+
8 rows in set (0.005 sec)

obclient [tpch]> use test;
Database changed
obclient [test]> show tables;
Empty set (0.001 sec)

obclient [test]> use tpch;
Database changed
obclient [tpch]> select count(*) from lineitem;
+----------+
| count(*) |
+----------+
| 59986052 |
+----------+
1 row in set (0.090 sec)

Expected Behavior

No response

Other Information

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions