Created 01-12-2015 09:09 PM
Hi All,
I recently installed CM5 with CDH5.3. When trying to run this below query -
SELECT sample_07.description, sample_07.salary
FROM
sample_07
WHERE
( sample_07.salary > 100000)
ORDER BY sample_07.salary DESC
LIMIT 1000
I get results. But, when I scroll down, I get more records compared to CDH Virtual Machine build.
26 | Optometrists | 101840 |
27 | Computer and information scientists, research | 100640 |
1 | Surgeons | 191410 |
NaN | 1 | Surgeons |
NaN | 2 | Orthodontists |
NaN | 3 | Obstetricians and gynecologists |
NaN | 4 | Oral and maxillofacial surgeons |
NaN | 5 | Prosthodontists |
NaN | 6 | Internists, general
|
Error Log from HUE directory -
[12/Jan/2015 20:59:30 -0800] base ERROR Internal Server Error: /impala/execute/design/7
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/build/env/lib/python2.6/site-packages/Django-1.4.5-py2.6.egg/django/core/handlers/base.py", line 111, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/apps/beeswax/src/beeswax/views.py", line 418, in execute_query
return render('execute.mako', request, context)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/desktop/core/src/desktop/lib/django_util.py", line 217, in render
return render_json(data, request.GET.get("callback"), status=status)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/desktop/core/src/desktop/lib/django_util.py", line 292, in render_json
json = encode_json(data, indent)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/desktop/core/src/desktop/lib/django_util.py", line 264, in encode_json
return simplejson.dumps(data, indent=indent, cls=Encoder)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/build/env/lib/python2.6/site-packages/simplejson-2.0.9-py2.6-linux-x86_64.egg/simplejson/__init__.py", line 237, in dumps
**kw).encode(obj)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/build/env/lib/python2.6/site-packages/simplejson-2.0.9-py2.6-linux-x86_64.egg/simplejson/encoder.py", line 200, in encode
chunks = self.iterencode(o, _one_shot=True)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/build/env/lib/python2.6/site-packages/simplejson-2.0.9-py2.6-linux-x86_64.egg/simplejson/encoder.py", line 260, in iterencode
return _iterencode(o, 0)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/desktop/core/src/desktop/lib/django_util.py", line 73, in default
return simplejson.JSONEncoder.default(self, o)
File "/opt/cloudera/parcels/CDH-5.3.0-1.cdh5.3.0.p0.30/lib/hue/build/env/lib/python2.6/site-packages/simplejson-2.0.9-py2.6-linux-x86_64.egg/simplejson/encoder.py", line 177, in default
raise TypeError(repr(o) + " is not JSON serializable")
TypeError: datetime.datetime(2015, 1, 12, 20, 59, 21, 857975) is not JSON serializable
statestored version 2.1.0-cdh5 RELEASE (build e48c2b48c53ea9601b8f47a39373aa83ff7ca6e2) Built on Tue, 16 Dec 2014 19:25:34 PST
catalogd version 2.1.0-cdh5 RELEASE (build e48c2b48c53ea9601b8f47a39373aa83ff7ca6e2) Built on Tue, 16 Dec 2014 19:25:34 PST
Created 04-13-2015 03:06 PM
*BUMP*
I'm having the same issue. It's seeming like perhaps a bug in the driver. I get expected results when using impala-shell, but the NaN erroneous results when using Hue and even in Tableau.
Did you ever get to the root of the issue?
Peter