Member since
12-09-2015
22
Posts
2
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
4803 | 04-25-2016 05:31 PM | |
3434 | 12-09-2015 02:40 PM |
04-25-2016
05:31 PM
This issue was corrected by using the sqlite3 command line interface and (alter table search_collection add column owner_id int NULL) No issues were seen after that.
... View more
04-25-2016
02:00 PM
For reference, the table in the database looks like this: CREATE TABLE "search_collection" ( "properties" text NOT NULL, "sorting_id" integer NOT NULL, "name" varchar(40) NOT NULL, "facets_id" integer NOT NULL, "enabled" bool NOT NULL, "label" varchar(100) NOT NULL, "is_core_only" bool NOT NULL, "result_id" integer NOT NULL, "cores" text NOT NULL, "id" integer NOT NULL PRIMARY KEY); and the create table command in hue looks like this: db.create_table('search_collection', ( ('properties', self.gf('django.db.models.fields.TextField')(default='{}')), ('sorting', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['search.Sorting'])), ('name', self.gf('django.db.models.fields.CharField')(max_length=40)), ('facets', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['search.Facet'])), ('enabled', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('label', self.gf('django.db.models.fields.CharField')(max_length=100)), ('is_core_only', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('result', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['search.Result'])), ('cores', self.gf('django.db.models.fields.TextField')(default='{}')), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), )) So the field "owner_id" is definitely not there, and it looks like it shouldn't be, so why is it an error? Can I just create an owner_id field with some default value, or will that mess up something worse?
... View more
04-25-2016
01:07 PM
I'm following the instructions: http://www.cloudera.com/documentation/enterprise/5-5-x/topics/cdh_ig_hue_database.html When dumping the sqlite database, I get the following error: sudo -u hue /opt/cloudera/parcels/CDH-5.7.0-1.cdh5.7.0.p0.45/lib/hue/build/env/bin/hue dumpdata > /tmp/huedump.json
CommandError: Unable to serialize database: no such column: search_collection.owner_id We started on version 5.3.3, upgraded to 5.4.7, and have now completed an upgrade to 5.7.0. Can anyone tell me how to fix/get around this?
... View more
Labels:
04-25-2016
09:23 AM
It looks like you installed Java as hduser instead of as root. This will prevent other users from accessing it. Could you try uninstalling java, and re-installing it as root?
... View more
12-09-2015
02:40 PM
This issue was resolved by removing the 5.3.6 libraries from the cluster. It seems that Cloudera leaves the old libraries in the path after the new libraries are installed.
... View more
12-09-2015
01:28 PM
I just upgraded my cluster from 5.3.6 to 5.4.8, and can no longer access my ORCFile formatted tables from Hive. It's giving me the following exception. CDH 5.4.8 states that it's using Hive 1.1.0, although this specific error is reported as existing in Hive 1.2, and is correctable by upgrading the Kryo library to the latest version. Has anyone else seen this? Is there a way of fixing it less severe than rolling back my installation? org.apache.hive.com.esotericsoftware.kryo.KryoException: java.lang.IndexOutOfBoundsException: Index: 109, Size: 75
Serialization trace:
operatorId (org.apache.hadoop.hive.ql.exec.vector.VectorFileSinkOperator)
childOperators (org.apache.hadoop.hive.ql.exec.vector.VectorSelectOperator)
childOperators (org.apache.hadoop.hive.ql.exec.vector.VectorFilterOperator)
childOperators (org.apache.hadoop.hive.ql.exec.TableScanOperator)
aliasToWork (org.apache.hadoop.hive.ql.plan.MapWork)
at org.apache.hive.com.esotericsoftware.kryo.serializers.ObjectField.read(ObjectField.java:125)
at org.apache.hive.com.esotericsoftware.kryo.serializers.FieldSerializer.read(FieldSerializer.java:507)
at org.apache.hive.com.esotericsoftware.kryo.Kryo.readClassAndObject(Kryo.java:776)
... View more
Labels: