Skip to content
New issue

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

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

Already on GitHub? # to your account

KeyError: 'nextResultUri' #68

Open
dermasmid opened this issue Dec 13, 2023 · 0 comments · May be fixed by #69
Open

KeyError: 'nextResultUri' #68

dermasmid opened this issue Dec 13, 2023 · 0 comments · May be fixed by #69

Comments

@dermasmid
Copy link

when trying to run i get KeyError: 'nextResultUri'.

the response data is

{'resultType': 'EOS', 'isQueryResult': False, 'resultKind': 'SUCCESS', 'results': {'columns': [{'name': 'result', 'logicalType': {'type': 'VARCHAR', 'nullable': True, 'length': 2147483647}, 'comment': None}], 'rowFormat': 'JSON', 'data': []}}

traceback:

13:23:19  Traceback (most recent call last):
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/main.py", line 135, in main
    results, succeeded = handle_and_check(args)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/main.py", line 198, in handle_and_check
    task, res = run_from_args(parsed)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/main.py", line 245, in run_from_args
    results = task.run()
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/task/runnable.py", line 472, in run
    result = self.execute_with_hooks(selected_uids)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/task/runnable.py", line 434, in execute_with_hooks
    self.before_run(adapter, selected_uids)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/task/run.py", line 428, in before_run
    self.safe_run_hooks(adapter, RunHookType.Start, {})
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/task/run.py", line 402, in safe_run_hooks
    self.run_hooks(adapter, hook_type, extra_context)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/task/run.py", line 351, in run_hooks
    sql = self.get_hook_sql(adapter, hook, idx, num_hooks, extra_context)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/task/run.py", line 307, in get_hook_sql
    compiled = compiler.compile_node(hook, self.manifest, extra_context)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/compilation.py", line 535, in compile_node
    node = self._compile_node(node, manifest, extra_context)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/compilation.py", line 394, in _compile_node
    compiled_node.compiled_code = jinja.get_rendered(
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 587, in get_rendered
    return render_template(template, ctx, node)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 542, in render_template
    return template.render(ctx)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/environment.py", line 1301, in render
    self.environment.handle_exception()
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/environment.py", line 936, in handle_exception
    raise rewrite_traceback_stack(source=source)
  File "<template>", line 1, in top-level template code
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 326, in __call__
    return self.call_macro(*args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 253, in call_macro
    return macro(*args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
  File "<template>", line 26, in template
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 326, in __call__
    return self.call_macro(*args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 253, in call_macro
    return macro(*args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
  File "<template>", line 2, in template
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 326, in __call__
    return self.call_macro(*args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/clients/jinja.py", line 253, in call_macro
    return macro(*args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
  File "<template>", line 11, in template
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/adapters/base/impl.py", line 278, in execute
    return self.connections.execute(sql=sql, auto_begin=auto_begin, fetch=fetch)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/adapters/sql/connections.py", line 126, in execute
    table = self.get_result_from_cursor(cursor)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/adapters/sql/connections.py", line 114, in get_result_from_cursor
    rows = cursor.fetchall()
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/adapters/flink/handler.py", line 49, in fetchall
    self._buffer_results()
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/dbt/adapters/flink/handler.py", line 137, in _buffer_results
    result = self.last_operation.get_result(next_page=next_page)
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/flink/sqlgateway/operation.py", line 94, in get_result
    return SqlGatewayResultParser.parse_result(response.json())
  File "/Users/cheskeltwersky/Documents/dbt-place/pipelines/test/venv/lib/python3.10/site-packages/flink/sqlgateway/result_parser.py", line 35, in parse_result
    next_result_url = data["nextResultUri"]
KeyError: 'nextResultUri'
@dermasmid dermasmid linked a pull request Dec 13, 2023 that will close this issue
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant