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

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
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

Successfully merging a pull request may close this issue.

1 participant