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

"Ingest periodically" is not working properly #1978

Closed
jeongeunkwon opened this issue Apr 30, 2019 · 1 comment
Closed

"Ingest periodically" is not working properly #1978

jeongeunkwon opened this issue Apr 30, 2019 · 1 comment
Assignees
Labels
bug Something isn't working @datasource Component Name : Datasource/Connection Management
Milestone

Comments

@jeongeunkwon
Copy link

Describe the bug
"Ingest once" was successfully processed when creating a datasource in the database, but "Ingest periodically" failed.

message : INGESTION_JDBC_QUERY_EXECUTION_ERROR
cause : JdbcDataConnectionException: Fail to query : Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:566 Invalid table alias or column reference ‘sch_index_query_top_daily’: (possible column names are: query, search_type, search_type_info, qc, cc, ranking, max_result_cnt, yqc, yranking, fluctuation, rank_day, part_day)

To Reproduce
Steps to reproduce the behavior:

  1. Go to the 4th step of create datasource(DB)
  2. Click on 'Ingest periodically'
  3. Set the granularity equal to the partition period
  4. Click on 'Next;
  5. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]

Additional context
Add any other context about the problem here.

@ufoscw
Copy link
Contributor

ufoscw commented Apr 30, 2019

@jeongeunkwon
please tell me additional information.
(DB type, Query statement...)

@ufoscw ufoscw self-assigned this Apr 30, 2019
@kyungtaak kyungtaak added this to the 3.3.0 milestone May 6, 2019
@kyungtaak kyungtaak added @datasource Component Name : Datasource/Connection Management bug Something isn't working labels May 6, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working @datasource Component Name : Datasource/Connection Management
Projects
None yet
Development

No branches or pull requests

3 participants