To use a table defined on Elasticsearchindex for arbitrary full text search

[Igor Kravzov]

down votefavorite
<http://stackoverflow.com/questions/37393733/hive-to-use-elasticsearch-defined-table-for-arbitrary-full-text-search#>

I know that it is possible to create Hive table with predefined query like
this

CREATE EXTERNAL TABLE artists (
    id      BIGINT,
    name    STRING,
    links   STRUCT<url:STRING, picture:STRING>)
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource' = 'radio/artists', **'es.query' = '?q=me*'**);

But if I don't know query upfront, how can I use ESs full text
capabilities? is there a way? Thanks in advance.