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


-- 
Gimantha Bandara
Software Engineer
WSO2. Inc : http://wso2.com
Mobile : +94714961919
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to