Hive Server - Error: Requested start date is not supported by any possible table.

[Dan6erbond]

I'm running Hive on Kubernetes. Starting the latest version of the app results in the following error in the graphql-hive/server container.

Error: Requested start date is not supported by any possible table.
    at pickTableByPeriod (file:https:///usr/src/app/@hive/server/index.js:303050:11)
    at OperationsReader.pickAggregationByPeriod (file:https:///usr/src/app/@hive/server/index.js:303726:27)
    at OperationsReader.requestsOverTimeOfTargets (file:https:///usr/src/app/@hive/server/index.js:304698:64)
    at OperationsManager.requestsOverTimeOfTargetsLoader.import_dataloader5.default.cacheKeyFn [as _batchLoadFn] (file:https:///usr/src/app/@hive/server/index.js:325126:41)
    at dispatchBatch (file:https:///usr/src/app/@hive/server/index.js:62995:31)
    at Timeout._onTimeout (file:https:///usr/src/app/@hive/server/index.js:62982:9)
    at listOnTimeout (node:internal/timers:573:17)
    at process.processTimers (node:internal/timers:514:7) {
  locations: [ { line: 21, column: 7 } ],
  path: [ 'projects', 'nodes', 1, 'requestsOverTime' ]
}

[andriihrachov]

same

[n1ru4l]

@andriihrachov @Dan6erbond Can you help us by sharing what views and which parameters cause this?

graphql-hive/packages/services/api/src/modules/operations/lib/pick-table-by-provider.ts

Line 39 in 3a45ffc

export function pickTableByPeriod(args: {

graphql-hive/packages/services/api/src/modules/operations/lib/pick-table-by-provider.ts

Lines 45 to 50 in 3a45ffc

	args.logger?.debug(
	'Picking table by period (from: %s, to: %s, intervalUnit: %s',
	args.period.from.toISOString(),
	args.period.to.toISOString(),
	args.intervalUnit ?? 'none',
	);

[andriihrachov]

In our case, self-healed with updating hive again. We also experienced problems with clickhouse connectivity, maybe it was the root cause, e.g. error is not correct in this case.

Once we updated hive & fixed connectivity issues - no errors so far.