Hi Gimantha, I used external HBase DB and DAS embedded H2 DB. I checked with HBase table and table-gadget column order same as HBase table. I tried with H2 table, but I couldn't see column names as I think it was encrypted or something. How can I check the column names in DAS embedded H2 database?
Thanks. On Fri, Aug 14, 2015 at 1:28 PM, Gimantha Bandara <[email protected]> wrote: > Hi Thanuja, > Is it same with the H2 table or only the HBase analytics table? > > > On Thu, Aug 13, 2015 at 6:50 PM, Thanuja Uruththirakodeeswaran < > [email protected]> wrote: > >> Hi, >> >> I've persisted a event stream in event store which is a HBase database. >> Then using the following query I created table in spark environment. Also I >> used H2 database as processed store. >> >> CREATE TEMPORARY TABLE memberinfo >> USING CarbonAnalytics >> OPTIONS (tableName "MEMBER_INFO"); >> >> CREATE TEMPORARY TABLE memberdetails >> USING CarbonAnalytics >> OPTIONS (tableName "MEMBER_DETAILS", schema "X STRING, Y STRING, Z >> STRING"); >> >> INSERT OVERWRITE TABLE memberdetails select * from memberinfo; >> >> Here MEMBER_INFO - HBase database table, MEMBER_DETAILS - H2 database >> table >> >> When I use the Data Explorer to see records in table "MEMBER_DETAILS", >> column order as specified in schema. But when I created a table gadget >> using the same table and added to dashboard, column order is not as in >> schema. But I think columns are in the order as in HBase database table. >> >> What I have to do to get the columns as in schema order? >> >> Thanks. >> >> -- >> Thanuja Uruththirakodeeswaran >> Software Engineer >> WSO2 Inc.;http://wso2.com >> lean.enterprise.middleware >> >> mobile: +94 774363167 >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Gimantha Bandara > Software Engineer > WSO2. Inc : http://wso2.com > Mobile : +94714961919 > -- Thanuja Uruththirakodeeswaran Software Engineer WSO2 Inc.;http://wso2.com lean.enterprise.middleware mobile: +94 774363167
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
