Done, thanks
On 3 April 2017 at 17:31, Lopez Sandoval, Everardo <[email protected]> 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 > <[email protected]<mailto:[email protected]>> 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 >
