You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yakov Zhdanov (JIRA)" <ji...@apache.org> on 2015/12/14 15:35:46 UTC

[jira] [Resolved] (IGNITE-2155) CacheStarSchemaExample isn't clear and it seems the output is wrong

     [ https://issues.apache.org/jira/browse/IGNITE-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yakov Zhdanov resolved IGNITE-2155.
-----------------------------------
    Resolution: Fixed
      Assignee: Ilya Suntsov  (was: Yakov Zhdanov)

I fixed the negative ids.
As far as example meaning you can try this https://en.wikipedia.org/wiki/Star_schema

> CacheStarSchemaExample isn't clear and it seems the output is wrong
> -------------------------------------------------------------------
>
>                 Key: IGNITE-2155
>                 URL: https://issues.apache.org/jira/browse/IGNITE-2155
>             Project: Ignite
>          Issue Type: Bug
>          Components: general
>    Affects Versions: 1.5
>            Reporter: Sergey Kozlov
>            Assignee: Ilya Suntsov
>             Fix For: 1.5
>
>
> I run {{org.apache.ignite.examples.datagrid.starschema.CacheStarSchemaExample}} and can't understand what actually it does and what the ouptut means (e.g. why all Ids are negative numbers)?
> {noformat}
> All purchases made at store1:
>     FactPurchase [id=-1604674364, productId=-1604674374, storeId=-1604674395, purchasePrice=10.0]
>     FactPurchase [id=-1604674362, productId=-1604674377, storeId=-1604674395, purchasePrice=12.0]
>     FactPurchase [id=-1604674349, productId=-1604674382, storeId=-1604674395, purchasePrice=25.0]
>     FactPurchase [id=-1604674346, productId=-1604674393, storeId=-1604674395, purchasePrice=28.0]
>     FactPurchase [id=-1604674343, productId=-1604674375, storeId=-1604674395, purchasePrice=31.0]
>     FactPurchase [id=-1604674342, productId=-1604674392, storeId=-1604674395, purchasePrice=32.0]
>     FactPurchase [id=-1604674337, productId=-1604674375, storeId=-1604674395, purchasePrice=37.0]
>     FactPurchase [id=-1604674332, productId=-1604674384, storeId=-1604674395, purchasePrice=42.0]
>     FactPurchase [id=-1604674325, productId=-1604674388, storeId=-1604674395, purchasePrice=49.0]
>     FactPurchase [id=-1604674323, productId=-1604674391, storeId=-1604674395, purchasePrice=51.0]
>     FactPurchase [id=-1604674317, productId=-1604674390, storeId=-1604674395, purchasePrice=57.0]
>     FactPurchase [id=-1604674316, productId=-1604674389, storeId=-1604674395, purchasePrice=58.0]
>     FactPurchase [id=-1604674311, productId=-1604674389, storeId=-1604674395, purchasePrice=63.0]
>     FactPurchase [id=-1604674305, productId=-1604674377, storeId=-1604674395, purchasePrice=69.0]
>     FactPurchase [id=-1604674300, productId=-1604674382, storeId=-1604674395, purchasePrice=74.0]
>     FactPurchase [id=-1604674296, productId=-1604674392, storeId=-1604674395, purchasePrice=78.0]
>     FactPurchase [id=-1604674295, productId=-1604674378, storeId=-1604674395, purchasePrice=79.0]
>     FactPurchase [id=-1604674293, productId=-1604674377, storeId=-1604674395, purchasePrice=81.0]
>     FactPurchase [id=-1604674289, productId=-1604674378, storeId=-1604674395, purchasePrice=85.0]
>     FactPurchase [id=-1604674285, productId=-1604674379, storeId=-1604674395, purchasePrice=89.0]
>     FactPurchase [id=-1604674281, productId=-1604674379, storeId=-1604674395, purchasePrice=93.0]
>     FactPurchase [id=-1604674371, productId=-1604674383, storeId=-1604674395, purchasePrice=3.0]
>     FactPurchase [id=-1604674370, productId=-1604674392, storeId=-1604674395, purchasePrice=4.0]
>     FactPurchase [id=-1604674368, productId=-1604674389, storeId=-1604674395, purchasePrice=6.0]
>     FactPurchase [id=-1604674363, productId=-1604674375, storeId=-1604674395, purchasePrice=11.0]
>     FactPurchase [id=-1604674357, productId=-1604674393, storeId=-1604674395, purchasePrice=17.0]
>     FactPurchase [id=-1604674355, productId=-1604674380, storeId=-1604674395, purchasePrice=19.0]
>     FactPurchase [id=-1604674353, productId=-1604674384, storeId=-1604674395, purchasePrice=21.0]
>     FactPurchase [id=-1604674348, productId=-1604674376, storeId=-1604674395, purchasePrice=26.0]
>     FactPurchase [id=-1604674340, productId=-1604674383, storeId=-1604674395, purchasePrice=34.0]
>     FactPurchase [id=-1604674339, productId=-1604674379, storeId=-1604674395, purchasePrice=35.0]
>     FactPurchase [id=-1604674336, productId=-1604674385, storeId=-1604674395, purchasePrice=38.0]
>     FactPurchase [id=-1604674335, productId=-1604674380, storeId=-1604674395, purchasePrice=39.0]
>     FactPurchase [id=-1604674333, productId=-1604674390, storeId=-1604674395, purchasePrice=41.0]
>     FactPurchase [id=-1604674331, productId=-1604674385, storeId=-1604674395, purchasePrice=43.0]
>     FactPurchase [id=-1604674329, productId=-1604674388, storeId=-1604674395, purchasePrice=45.0]
>     FactPurchase [id=-1604674327, productId=-1604674391, storeId=-1604674395, purchasePrice=47.0]
>     FactPurchase [id=-1604674322, productId=-1604674385, storeId=-1604674395, purchasePrice=52.0]
>     FactPurchase [id=-1604674321, productId=-1604674380, storeId=-1604674395, purchasePrice=53.0]
>     FactPurchase [id=-1604674319, productId=-1604674386, storeId=-1604674395, purchasePrice=55.0]
>     FactPurchase [id=-1604674315, productId=-1604674374, storeId=-1604674395, purchasePrice=59.0]
>     FactPurchase [id=-1604674314, productId=-1604674383, storeId=-1604674395, purchasePrice=60.0]
>     FactPurchase [id=-1604674312, productId=-1604674385, storeId=-1604674395, purchasePrice=62.0]
>     FactPurchase [id=-1604674302, productId=-1604674386, storeId=-1604674395, purchasePrice=72.0]
>     FactPurchase [id=-1604674298, productId=-1604674380, storeId=-1604674395, purchasePrice=76.0]
>     FactPurchase [id=-1604674291, productId=-1604674390, storeId=-1604674395, purchasePrice=83.0]
>     FactPurchase [id=-1604674282, productId=-1604674374, storeId=-1604674395, purchasePrice=92.0]
>     FactPurchase [id=-1604674279, productId=-1604674378, storeId=-1604674395, purchasePrice=95.0]
> IDs of products [p1=-1604674391, p2=-1604674380, p3=-1604674383]
> All purchases made at store2 for 3 specific products:
>     FactPurchase [id=-1604674366, productId=-1604674380, storeId=-1604674394, purchasePrice=8.0]
>     FactPurchase [id=-1604674354, productId=-1604674391, storeId=-1604674394, purchasePrice=20.0]
>     FactPurchase [id=-1604674308, productId=-1604674380, storeId=-1604674394, purchasePrice=66.0]
>     FactPurchase [id=-1604674341, productId=-1604674380, storeId=-1604674394, purchasePrice=33.0]
>     FactPurchase [id=-1604674338, productId=-1604674391, storeId=-1604674394, purchasePrice=36.0]
>     FactPurchase [id=-1604674334, productId=-1604674391, storeId=-1604674394, purchasePrice=40.0]
>     FactPurchase [id=-1604674318, productId=-1604674383, storeId=-1604674394, purchasePrice=56.0]
> {noformat}
> I suppose to refactor the example  and porvide more clear the output
> Same issue is for {{org.apache.ignite.scalar.examples.ScalarSnowflakeSchemaExample}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)