Impala does not implement the Hive Serde interface, but uses its own scanner implementations for efficiency. I'm afraid Impala will not work out-of-the-box on Hive tables with that Serde.
I'm not sure about the SolrStorageHandler, might want to ask on the Hive user list. On Wed, May 11, 2016 at 9:37 PM, Darren Hoo <[email protected]> wrote: > create an external table in hive using: > > > hive > > CREATE EXTERNAL TABLE twitter ( > id BIGINT, > text STRING > ) > STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler' > TBLPROPERTIES( > 'storage_handler' = 'org.elasticsearch.hadoop.hive.EsStorageHandler', > 'es.resource' = 'twitter/twiter', > 'es.query' = '?q=*' > ); > > > > but when try to query from impala shell, it shows: > > imapal-shell > select * from twitter; > > Query: select * from twitter > > ERROR: AnalysisException: Failed to load metadata for table: 'twitter' > > CAUSED BY: TableLoadingException: Unrecognized table type for table: > default. twitter > > > BTW, why SolrStorageHandler[1] is lost in CDH above 5.2, deprecated? > > [1] > http://101.251.213.60:7180/static/help/topics/search_use_solrstoragehandler.html > > -- > You received this message because you are subscribed to the Google Groups > "Impala User" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. >
