Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Errors when running example

Errors when running example

Explorer

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.

 

26Optometrists101840
27Computer and information scientists, research100640
1Surgeons191410
NaN1Surgeons
NaN2Orthodontists
NaN3Obstetricians and gynecologists
NaN4Oral and maxillofacial surgeons
NaN5Prosthodontists
NaN6

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




1 REPLY 1
Highlighted

Re: Errors when running example

New Contributor

*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

Don't have an account?
Coming from Hortonworks? Activate your account here