Given following Impala query:
SELECT date, SUM(CAST(price AS DOUBLE)) AS price
FROM table
WHERE date='2014-01-01' AND store_id IN(1,2,3)
GROUP BY date;
To work with Solr
1. Will it be more efficient to directly use equivalent Solr query? Any
curl command equivalent to the Impala query above? Or
2. Will it be faster to create a new table based on the query above with
Impala, and then connect Impala with Solr? Any such Impala-Solr connector?
The final goal is to use Kibana to connect Solr for visualization.
Any comments are greatly welcome!
Best,
Rex
