Hi Gimantha, Is there any solution to get Table Gadget column order as Data Explorer Table column order?
Thanks. On Fri, Aug 14, 2015 at 8:20 PM, Thanuja Uruththirakodeeswaran < thanu...@wso2.com> wrote: > Hi Gimantha, > > Yes gadget table columns are not in the order as in schema. Data explorer > has same column order as in schema. > > Thanks. > On 14 Aug 2015 18:18, "Gimantha Bandara" <giman...@wso2.com> wrote: > >> 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 >> > -- 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