cannot be cast to org.apache.hadoop.hive.serde2.Deserializer

treasure-data / prestogres

PostgreSQL protocol gateway for Presto distributed SQL query engine

Other

292 stars 61 forks source link

cannot be cast to org.apache.hadoop.hive.serde2.Deserializer #13

Open akunyer opened 10 years ago

akunyer commented 10 years ago

Hi , I have this error when trying to /dt inside the console

PrestoQueryException: Query 20140715_193328_00033_wys9z failed: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException java.lang.ClassCastException: org.apache.hadoop.hive.contrib.serde2.RegexSerDe cannot be cast to org.apache.hadoop.hive.serde2.Deserializer

Thanks

frsyuki commented 10 years ago

I guess there is a problem in Presto (especially in hive connector). Prestogres runs following query on Presto to get list of tables:

select table_schema, table_name, column_name, is_nullable, data_type" from information_schema.columns

Could you try to run this query using presto-cli? If it caused the same exception, that is a Presto's issue.

akunyer commented 10 years ago

Ok ill try it and let you know the results. Thanks.

FURUHASHI Sadayuki notifications@github.com wrote:

IguessthereisaprobleminPresto(especiallyinhiveconnector).PrestogresrunsfollowingqueryonPrestotogetlistoftables:selecttable_schema,table_name,column_name,is_nullable,data_type"frominformation_schema.columnsCouldyoutrytorunthisqueryusingpresto-cli?Ifitcausedthesameexception,thatisaPresto'sissue.ReplytothisemaildirectlyorviewitonGitHub.