spot-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Giacomo Bernardi <m...@minux.it>
Subject Re: Issue in SPOT-35_graphql_api new Impala's tables
Date Mon, 03 Apr 2017 16:42:03 GMT
Done, thanks

On 3 April 2017 at 17:31, Lopez Sandoval, Everardo
<everardo.lopez.sandoval@intel.com> wrote:
> Hi,
>
> Thanks for reporting this,
>
> JIRA: https://issues.apache.org/jira/browse/SPOT-35
>
> Can you please help us by adding this comment to the Jira (SPOT-35).
>
>
> Regards,
> Ever
>
>
>
> On Apr 3, 2017, at 11:12 AM, Giacomo Bernardi <mino@minux.it<mailto:mino@minux.it>>
wrote:
>
> I'm experimenting with the SPOT-35_graphql_api branch (which is epic
> work, looking forward for the merge!), and I found this small bug. As
> it's an experimental branch, I'm not sure how/where I should report it
> (jira? github?), sorry.
>
> In:
>  spot-setup/create_flow_parquet.hql
>
> line:
>  proto STRING,
>
> should be:
>  proto TINYINT,
>
> Otherwise, the OA backend will fail with the following traceback:
>    Traceback (most recent call last):
>      File "start_oa.py", line 82, in <module>
>        main()
>      File "start_oa.py", line 40, in main
>        start_oa(args)
>      File "start_oa.py", line 55, in start_oa
>        oa_process.start()
>      File "/home/spot/incubator-spot_graphql/spot-oa/oa/flow/flow_oa.py",
> line 88, in start
>        self._create_flow_scores()
>      File "/home/spot/incubator-spot_graphql/spot-oa/oa/flow/flow_oa.py",
> line 181, in _create_flow_scores
>        impala.execute_query(load_into_impala)
>      File "../api/resources/impala_engine.py", line 14, in execute_query
>        impala_cursor.execute(query)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 302, in execute
>        configuration=configuration)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 343, in execute_async
>        self._execute_async(op)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 362, in _execute_async
>        operation_fn()
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 340, in op
>        async=True)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 1027, in execute
>        return self._operation('ExecuteStatement', req)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 957, in _operation
>        resp = self._rpc(kind, request)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 925, in _rpc
>        err_if_rpc_not_ok(response)
>      File "/usr/local/lib/python2.7/dist-packages/impala/hiveserver2.py",
> line 704, in err_if_rpc_not_ok
>        raise HiveServer2Error(resp.status.errorMessage)
>    impala.error.HiveServer2Error: AnalysisException: Target table
> 'spot.flow_scores' is incompatible with source expressions.
>    Expression '17' (type: TINYINT) is not compatible with column
> 'proto' (type: STRING)
>
> I've worked around the issue with a quick:
>  impala-shell -d spot -q "ALTER TABLE flow_scores CHANGE proto proto tinyint;"
>
> Thanks,
> Giacomo
>

Mime
View raw message