Re: impala not support all hive tables?

[Alex Behm <al...@cloudera.com>]

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 <da...@gmail.com> 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 impala-user+unsubscribe@cloudera.org.
>