Gary, I think you should be able to query es index simply with SQL, no need to create any dimtable or fact table in lens, unless they are part of a cube you are trying.
Amruth, Can you help Gary on running queries on elastic search? Thanks On Tue, Jul 5, 2016 at 5:54 PM, Gary Wu <borderlayout...@gmail.com> wrote: > Hi Team, > I am trying to use *elasticsearch *as the data source for lens. I do as > follow: > 1) I make a new directory in driver dir and add a xml. > >> ..../server/conf/drivers/ >> >> >> *├── es│ └── es1│ └── esdriver-site.xml* >> ├── hive >> │ └── hive1 >> │ └── hivedriver-site.xml >> └── jdbc >> └── jdbc1 >> └── jdbcdriver-site.xml > > > <?xml version="1.0"?> >>> >> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> > > <configuration> >> >> <property> >> >> <name>lens.driver.es.term.fetch.size</name> >> >> <description>Fetch (buffer) size for document look up >>> queries</description> >> >> <value>10000</value> >> >> </property> >> >> <property> >> >> <name>lens.driver.es.query.timeout.millis</name> >> >> <description>Query timeout</description> >> >> <value>10000</value> >> >> </property> >> >> <property> >> >> <name>lens.driver.es.max.row.size</name> >> >> <description>max rows for es document look up queries, non existent >>> or -1 refers no limit</description> >> >> <value>-1</value> >> >> </property> >> >> <property> >> >> <name>lens.driver.es.aggr.bucket.size</name> >> >> <description>Max cardinality of group by (higher value means higher >>> resource usage at server end)</description> >> >> <value>6</value> >> >> </property> >> >> <property> >> >> <name>lens.driver.es.jest.servers</name> >> >> <description>List of http servers, will be used on a round robin >>> basis</description> >> >> <value>*http://10.10.44.21:19200 <http://10.10.44.21:19200>*</value> >> >> </property> >> >> <property> >> >> <name>lens.driver.es.jest.max.conn</name> >> >> <description>max connections</description> >> >> <value>20</value> >> >> </property> >> >> <property> >> >> <name>lens.driver.es.client.class</name> >> >> <description>Choice of client class, default is >>> JestClientImpl</description> >> >> <value>org.apache.lens.driver.es.client.jest.JestClientImpl</value> >> >> </property> >> >> </configuration> >> >> > 2) Then I edit a driver item in lens-site.xml by > >> <property> >> >> <name>lens.server.drivers</name> >> >> >>> >>> <value>hive:org.apache.lens.driver.hive.HiveDriver,jdbc:org.apache.lens.driver.jdbc.JDBCDriver, >>> *es:org.apache.lens.driver.es.ESDriver*</value> >> >> </property> >> >> > In my elasticsearch (http://10.10.44.21:19200), there is *already *a > doc,named > index/type/index .... > plant/flower/1 .... > plant/flower/2 .... > plant/flower/3 .... > > *What should I do next for querying the data from es *? add dim or > dimtable ? I did not find examples for elasticsearch in lens document. > Could you give me some instructions or some examples for that ? > > Thank you very much. > Gary >
