question Re: HIVE ERROR? in Archives of Support Questions (Read Only)

HIVE ERROR?

rushikeshdeshmu — Thu, 18 Feb 2016 19:44:52 GMT

Facing below ERROR:

table missing : "`SKEWED_STRING_LIST`" in Catalog "" Schema "".

Can anyone help me on this?

Re: HIVE ERROR?

nsabharwal — Thu, 18 Feb 2016 19:48:51 GMT

@Rushikesh Deshmukh

Are you using HDP? If yes then whats the version?

Most of google search is pointing to CDH issue.

Re: HIVE ERROR?

rushikeshdeshmu — Thu, 18 Feb 2016 19:54:53 GMT

@Neeraj Sabharwal, I faced that issue on CDH platform, but does similar issue is faced on HDP as well? I had not tried this on HDP, but like to know possible cause if same issue is faced on HDP.

Re: HIVE ERROR?

rushikeshdeshmu — Thu, 18 Feb 2016 20:10:10 GMT

I got below answer which solved this ERROR:

Steps:

cd /usr/lib/hive/scripts/metastore/upgrade/mysql

sudo mysql --user=root

use metastore;

source upgrade-0.9.0-to-0.10.0.mysql.sql