Hi Dunith, Are we internally processing the columns in the schema in gadget generation.. Like changing the column order? Or are we simply iterating the columns in the schema returned by JS API when creating gadgets?
On 8/24/15, Thanuja Uruththirakodeeswaran <[email protected]> wrote: > 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 < > [email protected]> 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" <[email protected]> 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 <[email protected]> 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 <[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 >>> > >>> >>> >>> -- >>> 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 [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
