Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

failed to import data into database when stream contains a.b field #36

Open
shirley-gu-timeplus opened this issue Oct 24, 2024 · 2 comments

Comments

@shirley-gu-timeplus
Copy link

Issue Description

  • Description of the issue:
    failed to import data into database when stream contains a.b field

  • Sling version (sling --version):
    1.2.20-rc11-timeplus
    1.2.20-rc13-timeplus

  • Operating System (linux, mac, windows):
    linux

  • Replication Configuration:

source: DAILY_TIMEPLUS
target: HISTORICAL_TIMEPLUS
streams:
  i_positionHoldingAmount_fix3:
    update_key: _tp_time
    object: gj_i_positionHoldingAmount_fix3
  • Log Output (please run command with -d):
~ could not bulk import
--- database.go:1590 GetColumns ---
~ could not get matching list of columns from table
--- database.go:1506 GetTableColumns ---
provided field 'd__tp_time' not found in table `default`.`gj_i_positionHoldingAmount_fix3

1024_sling_rc11_i_positionHoldingAmount_fix3.log

@kuiliu88
Copy link

Please check if this is only applicable to Sling CLI or same for SQL statement " INSERT INTO...". and try if can workaround by put column name in ` quote.

@shirley-gu-timeplus
Copy link
Author

shirley-gu-timeplus commented Oct 30, 2024

It is only applicable to sling, not for timeplusd

  • I manually insert data into this table and success
  • for huatai script used in ec2, the table with this filed could be insert into data successfully.

try workaround with ` quote but not work either

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants