Columns you define in the schema, does not map to RDBMS physical tables' columns. Are you saying that the gadget tables that you create, do not have the column order as it is in the schema? Is it in the same order in the Data explorer?
On 8/14/15, Thanuja Uruththirakodeeswaran <thanu...@wso2.com> wrote: > 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 <giman...@wso2.com> > 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 < >> 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 >> > > > > -- > Thanuja Uruththirakodeeswaran > Software Engineer > WSO2 Inc.;http://wso2.com > lean.enterprise.middleware > > mobile: +94 774363167 > -- 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
