[
https://issues.apache.org/jira/browse/HIVE-22714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere updated HIVE-22714:
------------------------------
Assignee: Jason Dere
Status: Patch Available (was: Open)
Patch fixes the test by waiting for a longer amount of time (up to 30 secs)
before moving onto the select statement.
[~kgyrtkirk] can you review?
> TestScheduledQueryService is flaky
> ----------------------------------
>
> Key: HIVE-22714
> URL: https://issues.apache.org/jira/browse/HIVE-22714
> Project: Hive
> Issue Type: Bug
> Components: Tests
> Reporter: Jason Dere
> Assignee: Jason Dere
> Priority: Major
> Attachments: HIVE-22714.1.patch
>
>
> {noformat}
> [ERROR] Failures:
> [ERROR] TestScheduledQueryService.testScheduledQueryExecution:152
> Expected: <5>
> but: was <0>
> [INFO]
> [ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
> {noformat}
> Looks like sometimes we are not waiting long enough for the INSERT query to
> complete and the SELECT runs before it finishes:
> {noformat}
> $ egrep "insert|select"
> target/surefire-reports/org.apache.hadoop.hive.ql.schq.TestScheduledQueryService-output.txt
> | grep HOOK
> PREHOOK: query: insert into tu values(1),(2),(3),(4),(5)
> 2020-01-09T14:49:09,497 INFO [SchQ 0] SessionState: PREHOOK: query: insert
> into tu values(1),(2),(3),(4),(5)
> PREHOOK: query: select 1 from tu
> 2020-01-09T14:49:11,452 INFO [main] SessionState: PREHOOK: query: select 1
> from tu
> POSTHOOK: query: select 1 from tu
> 2020-01-09T14:49:11,452 INFO [main] SessionState: POSTHOOK: query: select 1
> from tu
> POSTHOOK: query: insert into tu values(1),(2),(3),(4),(5)
> 2020-01-09T14:49:12,062 INFO [SchQ 0] SessionState: POSTHOOK: query: insert
> into tu values(1),(2),(3),(4),(5)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
