HIVE ERROR?

[#1]

Facing below ERROR:

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

-

Can anyone help me on this?

[#2]

@Rushikesh Deshmukh

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

Most of google search is pointing to CDH issue.

[#3]

@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.

[#4 · Accepted solution]

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