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
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to