@Jason thanks , but now as suggested by Saofeng I m not using the inverted index brach as its not stable. I have switched back to 0.6 branch , in this branch yesterday night I could crete the cube successfully but there is issue while building it. I feel that at step 1 of cube build while creating flat table when command is issued to hive if the tables are not under default datbase flat table creation is failed and cube build fails. my fact and dimension tables are under a database called retail.
@Saofeng - Can you please confirm this behavior ? Do I need to create the hive tables under default database? On Fri, Feb 27, 2015 at 7:32 AM, jason zhong <[email protected]> wrote: > @Santoshakhilesh > > 1. When I go to measure section and click on measure option , there is no > response , I want add measure on qty and price with sum > --bug fixed on inverted-index branch > > > On Fri, Feb 27, 2015 at 3:03 AM, Santosh Akhilesh < > [email protected] > > wrote: > > > Hi Shaofeng , > > I have build the 0.6 version and now able to create the cube > > successfully. > > While building the cube , it fails at step1 with following error. > > Table not found 'DIM_ITEM' > > the table exists , but its under retail data base and not under > > default database. > > does kylin require hive taables to be under default database ? I see > > the flat table being created under default database. > > > > Logging initialized using configuration in > > > > > jar:file:/home/santosh/work/frameworks/apache-hive-1.0.0/lib/hive-common-1.0.0.jar!/hive-log4j.properties > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > > > > > [jar:file:/home/santosh/work/frameworks/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > > > > > [jar:file:/home/santosh/work/frameworks/apache-hive-1.0.0/lib/hive-jdbc-1.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > > explanation. > > SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] > > OK > > Time taken: 0.964 seconds > > OK > > Time taken: 0.948 seconds > > FAILED: SemanticException [Error 10001]: Line 12:11 Table not found > > 'DIM_ITEM' > > > > > > > > Command is as below. > > > > hive -e "DROP TABLE IF EXISTS > > kylin_intermediate_test_FULL_BUILD_8b30b29b_5f2c_4b63_8c0f_07d1f559dd44; > > CREATE EXTERNAL TABLE IF NOT EXISTS > > kylin_intermediate_test_FULL_BUILD_8b30b29b_5f2c_4b63_8c0f_07d1f559dd44 > > ( > > STOREID int > > ,ITEMID int > > ,CUSTID int > > ,QTY int > > ,AMOUNT double > > ) > > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177' > > STORED AS SEQUENCEFILE > > LOCATION > > > '/tmp/kylin-8b30b29b-5f2c-4b63-8c0f-07d1f559dd44/kylin_intermediate_test_FULL_BUILD_8b30b29b_5f2c_4b63_8c0f_07d1f559dd44'; > > SET hive.exec.compress.output=true; > > SET hive.auto.convert.join.noconditionaltask = true; > > SET hive.auto.convert.join.noconditionaltask.size = 300000000; > > INSERT OVERWRITE TABLE > > kylin_intermediate_test_FULL_BUILD_8b30b29b_5f2c_4b63_8c0f_07d1f559dd44 > > SELECT > > FACT_SALES.STOREID > > ,FACT_SALES.ITEMID > > ,FACT_SALES.CUSTID > > ,FACT_SALES.QTY > > ,FACT_SALES.AMOUNT > > FROM FACT_SALES > > INNER JOIN DIM_STORE > > ON FACT_SALES.STOREID = DIM_STORE.SROREID > > INNER JOIN DIM_ITEM > > ON FACT_SALES.ITEMID = DIM_ITEM.ITEMID > > INNER JOIN DIM_CUSTOMER > > ON FACT_SALES.CUSTID = DIM_CUSTOMER.CUSTID > > ; > > " > > > > > > > > On Thu, Feb 26, 2015 at 8:11 PM, Shi, Shaofeng <[email protected]> wrote: > > > > > The 0.7.1 is test version, its package contains the “snapshot” suffix; > we > > > will upload a new package there; Luke will also add a message there to > > > avoid this confusion; > > > > > > Regarding the problem that you encountered, could you please open a > JIRA > > > ticket for tracking? Here is link of Apache JIRA: > > > > > > https://issues.apache.org/jira/secure/Dashboard.jspa > > > > > > > > > Thanks for the feedback! > > > > > > On 2/26/15, 10:21 PM, "Santosh Akhilesh" <[email protected]> > > > wrote: > > > > > > >Actually I see this being published on kylin webpage. > > > >http://kylin.incubator.apache.org/download/ > > > >I am using 0.7.1 inverted index branch binary distribution. > > > >If this is not stable please give me the link of stable branch I would > > try > > > >building and testing tonight. > > > >On Thu, 26 Feb 2015 at 7:30 pm, Shi, Shaofeng <[email protected]> > wrote: > > > > > > > >> Hi Santosh, it is not recommended to use the dev code branch > > (actually I > > > >> don’t know how you get the v0.7.x build and what’s the detail > version > > of > > > >> that; each day we submit many changes to that); > > > >> > > > >> The options are 1) switch back to latest release v0.6.5; or 2) wait > > for > > > >> the formal release of 0.7, that should be in March; Otherwise, we > > > >>couldn’t > > > >> ensure there is no new problems come out in your next steps; > > > >> > > > >> On 2/26/15, 5:39 PM, "Santosh Akhilesh" <[email protected]> > > > >>wrote: > > > >> > > > >> >Hi Shaofeng > > > >> >So what do you suggest , how should I proceed further with this > > > >>release? > > > >> >Will there be a patch? Any alternate way I can create cube? > > > >> >Please suggest. > > > >> >Regards > > > >> >Santosh > > > >> >On Thu, 26 Feb 2015 at 3:04 pm, Shi, Shaofeng <[email protected]> > > > wrote: > > > >> > > > > >> >> Hi Santosh, > > > >> >> > > > >> >> 0.7.1 hasn’t been formally released; from 0.6.x to 0.7.x we have > > > >> >>metadata > > > >> >> structure change; While, the web UI (cube wizard) for this change > > > >>hasn’t > > > >> >> been stabilized; So it is not strange that you got trouble when > > > >>saving > > > >> >>the > > > >> >> cube; > > > >> >> > > > >> >> @Jason, any idea about the JS error? > > > >> >> > > > >> >> On 2/26/15, 5:08 PM, "Santosh Akhilesh" < > [email protected] > > > > > > >> >>wrote: > > > >> >> > > > >> >> >Hi Shaofeng, > > > >> >> > > > > >> >> >I am using the binary distribution 0.7.1. I have not been able > to > > > >>save > > > >> >> >cube > > > >> >> >even once. I have tried creating new project and from local > > machine > > > >>and > > > >> >> >server machine. But I am always stuck with this error. I am > never > > > >> >>allowed > > > >> >> >to add measures and never been able to save the cube. I also see > > the > > > >> >> >kylin.log and it always tries to save cube with append mode. One > > > >>thing > > > >> >>I > > > >> >> >need to tell that at partition stage since I don't have a big > fact > > > >> >>table > > > >> >> >now I have not partititioned the fact table and I skip this > step. > > > >>Does > > > >> >> >this > > > >> >> >have affect in saving the cube. Is this because some metadata is > > > >> >>available > > > >> >> >and it tries to modify the cube? I am using latest Hadoop 2.6.6. > > Yes > > > >> >>kylin > > > >> >> >propert I have not added the jar. I will add them and check. But > > > >>cube > > > >> >> >creation failure is really puzzling me. I could see no error > logs > > in > > > >> >> >kylin.log. > > > >> >> >Regards > > > >> >> >Santosh > > > >> >> >On Thu, 26 Feb 2015 at 1:40 pm, Shi, Shaofeng <[email protected] > > > > > >> wrote: > > > >> >> > > > > >> >> >> Which version or code branch are you using? I assume you’re > > using > > > >>the > > > >> >> >> stable version from master; Seems you’re trying to edit an > > > >>existing > > > >> >>cube > > > >> >> >> to add new measurement, try refresh your browser's cache; if > it > > > >>still > > > >> >> >> couldn’t be saved, try to create a new cube; > > > >> >> >> > > > >> >> >> The two error traces in tomcat need be taken care: > > > >> >> >> > > > >> >> >> 1) java.lang.NoClassDefFoundError: > > > >> >> >>org/apache/kylin/common/mr/KylinMapper > > > >> >> >> Please check kylin.properties file, making sure the > > > >> >> >>“kylin.job.jar” > > > >> >> >> points to a right jar file; It will be loaded in Map-reduce; > > > >> >> >> > > > >> >> >> 2) java.lang.IllegalArgumentException: No enum constant > > > >> >> >> org.apache.hadoop.mapreduce.JobCounter.MB_MILLIS_MAPS > > > >> >> >> This indicates your hadoop version might be old; > Please > > > >>check > > > >> >> >>and > > > >> >> >> ensure > > > >> >> >> hadoop version is 2.2 or above. > > > >> >> >> > > > >> >> >> On 2/26/15, 3:21 PM, "Santoshakhilesh" > > > >><[email protected]> > > > >> >> >> wrote: > > > >> >> >> > > > >> >> >> >Hi Shaofeng , > > > >> >> >> > > > > >> >> >> > I am using chrome , When I click on button to add > measures , > > > >> >> >>following > > > >> >> >> >is error on chrome console. When I try to save the cube there > > is > > > >>no > > > >> >> >>error > > > >> >> >> >in console. I just get a error dialog saying failed to take > > > >>action > > > >> >>and > > > >> >> >> >gives me the JSON cube schema. > > > >> >> >> > > > > >> >> >> >Error on chrome debug console is as below; > > > >> >> >> > > > > >> >> >> > ReferenceError: CubeDescModel is not defined > > > >> >> >> > at h.$scope.addNewMeasure (scripts.min.0.js:15984) > > > >> >> >> > at scripts.min.0.js:180 > > > >> >> >> > at scripts.min.0.js:197 > > > >> >> >> > at h.$eval (scripts.min.0.js:119) > > > >> >> >> > at h.$apply (scripts.min.0.js:119) > > > >> >> >> > at HTMLButtonElement.<anonymous> (scripts.min.0.js:197) > > > >> >> >> > at HTMLButtonElement.m.event.dispatch > (scripts.min.0.js:3) > > > >> >> >> > at HTMLButtonElement.r.handle > > > >> >> >> >(scripts.min.0.js:3)scripts.min.0.js:100 (anonymous > > > >> >> >> >function)scripts.min.0.js:77 (anonymous > > > >> >>function)scripts.min.0.js:119 > > > >> >> >> >h.$applyscripts.min.0.js:197 (anonymous > > > >>function)scripts.min.0.js:3 > > > >> >> >> >m.event.dispatchscripts.min.0.js:3 r.handle > > > >> >> >> > > > > >> >> >> > About the hive table import , I got pass the run shell > > command > > > >> >> >> >exception but it still fails the hadoop log is; > > > >> >> >> >2015-02-26 20:46:48,332 INFO [main] org.apache.hadoop.mapred. > > > >> >> YarnChild: > > > >> >> >> >mapreduce.cluster.local.dir for child: > > > >> >> >> >/tmp/hadoop-root/nm-local-dir/usercache/root/appcache/appli > > > >> >> >> cation_14249530 > > > >> >> >> >91340_0002 > > > >> >> >> >2015-02-26 20:46:48,776 INFO [main] > > > >> >> >> >org.apache.hadoop.conf.Configuration.deprecation: session.id > > is > > > >> >> >> >deprecated. Instead, use dfs.metrics.session-id > > > >> >> >> >2015-02-26 20:46:49,310 INFO [main] > > > >>org.apache.hadoop.mapred.Task: > > > >> >> >>Using > > > >> >> >> >ResourceCalculatorProcessTree : [ ] > > > >> >> >> >2015-02-26 20:46:49,386 FATAL [main] > > > >> >> >>org.apache.hadoop.mapred.YarnChild: > > > >> >> >> >Error running child : java.lang.NoClassDefFoundError: > > > >> >> >> >org/apache/kylin/common/mr/KylinMapper > > > >> >> >> > at java.lang.ClassLoader.defineClass1(Native Method) > > > >> >> >> > at java.lang.ClassLoader.defineClass(ClassLoader.java:800) > > > >> >> >> > at > > > >> >> >> >java.security.SecureClassLoader.defineClass( > > > >> >> SecureClassLoader.java:142) > > > >> >> >> > at > > java.net.URLClassLoader.defineClass(URLClassLoader.java:449) > > > >> >> >> > at > java.net.URLClassLoader.access$100(URLClassLoader.java:71) > > > >> >> >> > at java.net.URLClassLoader$1.run(URLClassLoader.java:361) > > > >> >> >> > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > > > >> >> >> > at java.security.AccessController.doPrivileged(Native > Method) > > > >> >> >> > at > java.net.URLClassLoader.findClass(URLClassLoader.java:354) > > > >> >> >> > at java.lang.ClassLoader.loadClass(ClassLoader.java:425) > > > >> >> >> > at > > sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > > > >> >> >> > > > > >> >> >> >tomcat logs: > > > >> >> >> >usage: HiveColumnCardinalityJob > > > >> >> >> > -output <path> Output path > > > >> >> >> > -table <table name> The hive table name > > > >> >> >> >[pool-4-thread-2]:[2015-02-26 > > > >> >> >> >20:47:49,936][ERROR][org.apache.kylin.job.common.HadoopShel > > > >> >> >> lExecutable.doW > > > >> >> >> >ork(HadoopShellExecutable.java:64)] - error execute > > > >> >> >> > > >HadoopShellExecutable{id=d4730d26-7fe6-412e-9841-3288ab362c5b-00, > > > >> >> >> >name=null, state=RUNNING} > > > >> >> >> >java.lang.IllegalArgumentException: No enum constant > > > >> >> >> >org.apache.hadoop.mapreduce.JobCounter.MB_MILLIS_MAPS > > > >> >> >> > at java.lang.Enum.valueOf(Enum.java:236) > > > >> >> >> > at > > > >> >> >> > > > >>>org.apache.hadoop.mapreduce.counters.FrameworkCounterGroup.valueOf( > > > >> >> >> Framewo > > > >> >> >> >rkCounterGroup.java:148) > > > >> >> >> > at > > > >> >> >> >org.apache.hadoop.mapreduce.counters.FrameworkCounterGroup. > > > >> >> >> findCounter(Fra > > > >> >> >> >meworkCounterGroup.java:182) > > > >> >> >> > at > > > >> >> >> >org.apache.hadoop.mapreduce.counters.AbstractCounters.findC > > > >> >> >> ounter(Abstract > > > >> >> >> >Counters.java:154) > > > >> >> >> > at > > > >> >> >> >org.apache.hadoop.mapreduce.TypeConverter.fromYarn(TypeConv > > > >> >> >> erter.java:240) > > > >> >> >> > at > > > >> >> >> >org.apache.hadoop.mapred.ClientServiceDelegate.getJobCounte > > > >> >> >> rs(ClientServic > > > >> >> >> >eDelegate.java:370) > > > >> >> >> > at > > > >> >> >> >org.apache.hadoop.mapred.YARNRunner.getJobCounters( > > > >> >> YARNRunner.java:511) > > > >> >> >> > at org.apache.hadoop.mapreduce.Job$7.run(Job.java:756) > > > >> >> >> > at org.apache.hadoop.mapreduce.Job$7.run(Job.java:753) > > > >> >> >> > at java.security.AccessController.doPrivileged(Native > Method) > > > >> >> >> > at javax.security.auth.Subject.doAs(Subject.java:415) > > > >> >> >> > at > > > >> >> >> >org.apache.hadoop.security.UserGroupInformation.doAs(UserGr > > > >> >> >> oupInformation. > > > >> >> >> >java:1491) > > > >> >> >> > at org.apache.hadoop.mapreduce.Job.getCounters(Job.java:753) > > > >> >> >> > at > > > >> >>org.apache.hadoop.mapreduce.Job.monitorAndPrintJob(Job.java:1361) > > > >> >> >> > at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job. > > > >> java:1289) > > > >> >> >> > at > > > >> >> >> >org.apache.kylin.job.hadoop.AbstractHadoopJob.waitForComple > > > >> >> >> tion(AbstractHa > > > >> >> >> >doopJob.java:134) > > > >> >> >> > at > > > >> >> >> > > > >> > > >>>org.apache.kylin.job.hadoop.cardinality.HiveColumnCardinalityJob.run( > > > >> >> >> HiveC > > > >> >> >> >olumnCardinalityJob.java:114) > > > >> >> >> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > > > >> >> >> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84) > > > >> >> >> > at > > > >> >> >> >org.apache.kylin.job.common.HadoopShellExecutable.doWork(Ha > > > >> >> >> doopShellExecut > > > >> >> >> >able.java:62) > > > >> >> >> > at > > > >> >> >> >org.apache.kylin.job.execution.AbstractExecutable.execute(A > > > >> >> >> bstractExecutab > > > >> >> >> >le.java:99) > > > >> >> >> > at > > > >> >> >> >org.apache.kylin.job.execution.DefaultChainedExecutable.doW > > > >> >> >> ork(DefaultChai > > > >> >> >> >nedExecutable.java:50) > > > >> >> >> > at > > > >> >> >> >org.apache.kylin.job.execution.AbstractExecutable.execute(A > > > >> >> >> bstractExecutab > > > >> >> >> >le.java:99) > > > >> >> >> > at > > > >> >> >> >org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRu > > > >> >> >> nner.run(Defaul > > > >> >> >> >tScheduler.java:132) > > > >> >> >> > at > > > >> >> >> >java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoo > > > >> >> >> lExecutor.java: > > > >> >> >> >1145) > > > >> >> >> > at > > > >> >> >> >java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPo > > > >> >> >> olExecutor.java > > > >> >> >> >:615) > > > >> >> >> > at java.lang.Thread.run(Thread.java:745) > > > >> >> >> > > > > >> >> >> >Regards, > > > >> >> >> >Santosh Akhilesh > > > >> >> >> >Bangalore R&D > > > >> >> >> >HUAWEI TECHNOLOGIES CO.,LTD. > > > >> >> >> > > > > >> >> >> >www.huawei.com > > > >> >> >> >----------------------------------------------------------- > > > >> >> >> --------------- > > > >> >> >> >----------------------------------------------------------- > > > >> >> >> >This e-mail and its attachments contain confidential > > information > > > >> >>from > > > >> >> >> >HUAWEI, which > > > >> >> >> >is intended only for the person or entity whose address is > > listed > > > >> >> >>above. > > > >> >> >> >Any use of the > > > >> >> >> >information contained herein in any way (including, but not > > > >>limited > > > >> >>to, > > > >> >> >> >total or partial > > > >> >> >> >disclosure, reproduction, or dissemination) by persons other > > than > > > >> >>the > > > >> >> >> >intended > > > >> >> >> >recipient(s) is prohibited. If you receive this e-mail in > > error, > > > >> >>please > > > >> >> >> >notify the sender by > > > >> >> >> >phone or email immediately and delete it! > > > >> >> >> > > > > >> >> >> >________________________________________ > > > >> >> >> >From: Shi, Shaofeng [[email protected]] > > > >> >> >> >Sent: Thursday, February 26, 2015 11:32 AM > > > >> >> >> >To: [email protected] > > > >> >> >> >Cc: Kulbhushan Rana > > > >> >> >> >Subject: Re: Error while making cube & Measure option is not > > > >> >>responding > > > >> >> >> >on GUI > > > >> >> >> > > > > >> >> >> >Hi Santosh, hive table importing issue should not impact on > > cube > > > >> >> >>saving. > > > >> >> >> > > > > >> >> >> >If you couldn’t save the cube, firstly please check whether > > > >>there is > > > >> >> >>error > > > >> >> >> >in the tomcat’s log; If not please check your web browser; We > > > >> >>suggest > > > >> >> >>use > > > >> >> >> >Firefox (with firebug add-on) or Chrome, open the JS console > > > >>(press > > > >> >> >>F12) > > > >> >> >> >and then operate web UI, check whether there is any error > > > >>reported > > > >> >>in > > > >> >> >> >browser. > > > >> >> >> > > > > >> >> >> > > > > >> >> >> >On 2/26/15, 1:08 PM, "Santoshakhilesh" > > > >><[email protected] > > > >> > > > > >> >> >> >wrote: > > > >> >> >> > > > > >> >> >> >>Hi Shaofeng , > > > >> >> >> >> Thanks for replying. > > > >> >> >> >> Yes I am checking the yarn exception, But I find that > this > > > >>error > > > >> >> >>comes > > > >> >> >> >>while importing the hive table to kylin. > > > >> >> >> >> Even if this error comes , hive tables is exported > > > >>successfully > > > >> >>in > > > >> >> >> >>kylin. Is this the reason why cube saving has failed ? > > > >> >> >> >> > > > >> >> >> >> Next step when I go on creating the cube for following > > > >>schema I > > > >> >> >>get > > > >> >> >> >>error at last step while saving and I am unable to add any > > > >> >>measures , > > > >> >> >> >>clicking on measure option just dont pop up any dialog, > > > >> >> >> >> > > > >> >> >> >>I am using star schema with fact_sales as fact table and > dim_* > > > >>as > > > >> >> >> >>dimension tables. > > > >> >> >> >> > > > >> >> >> >> fact_sales: > > > >> >> >> >> storeid int > > > >> >> >> >> itemid int > > > >> >> >> >> custid int > > > >> >> >> >> qty int > > > >> >> >> >> price double > > > >> >> >> >> > > > >> >> >> >>dim_customer > > > >> >> >> >> custid int > > > >> >> >> >> name string > > > >> >> >> >> > > > >> >> >> >> dim_item > > > >> >> >> >> itemid int > > > >> >> >> >> category string > > > >> >> >> >> brand string > > > >> >> >> >> color string > > > >> >> >> >> > > > >> >> >> >>dim_store > > > >> >> >> >> storeid int > > > >> >> >> >> city string > > > >> >> >> >> state string > > > >> >> >> >> > > > >> >> >> >>JSON is as below. > > > >> >> >> >> The JSON is as below. > > > >> >> >> >> > > > >> >> >> >> { > > > >> >> >> >> "name": "Retail_Cube", > > > >> >> >> >> "description": "", > > > >> >> >> >> "dimensions": [ > > > >> >> >> >> { > > > >> >> >> >> "name": "RETAIL.FACT_SALES.STOREID", > > > >> >> >> >> "table": "RETAIL.FACT_SALES", > > > >> >> >> >> "hierarchy": false, > > > >> >> >> >> "derived": null, > > > >> >> >> >> "column": [ > > > >> >> >> >> "STOREID" > > > >> >> >> >> ], > > > >> >> >> >> "id": 1 > > > >> >> >> >> }, > > > >> >> >> >> { > > > >> >> >> >> "name": "RETAIL.FACT_SALES.ITEMID", > > > >> >> >> >> "table": "RETAIL.FACT_SALES", > > > >> >> >> >> "hierarchy": false, > > > >> >> >> >> "derived": null, > > > >> >> >> >> "column": [ > > > >> >> >> >> "ITEMID" > > > >> >> >> >> ], > > > >> >> >> >> "id": 2 > > > >> >> >> >> }, > > > >> >> >> >> { > > > >> >> >> >> "name": "RETAIL.FACT_SALES.CUSTID", > > > >> >> >> >> "table": "RETAIL.FACT_SALES", > > > >> >> >> >> "hierarchy": false, > > > >> >> >> >> "derived": null, > > > >> >> >> >> "column": [ > > > >> >> >> >> "CUSTID" > > > >> >> >> >> ], > > > >> >> >> >> "id": 3 > > > >> >> >> >> } > > > >> >> >> >> ], > > > >> >> >> >> "measures": [ > > > >> >> >> >> { > > > >> >> >> >> "id": 1, > > > >> >> >> >> "name": "_COUNT_", > > > >> >> >> >> "function": { > > > >> >> >> >> "expression": "COUNT", > > > >> >> >> >> "returntype": "bigint", > > > >> >> >> >> "parameter": { > > > >> >> >> >> "type": "constant", > > > >> >> >> >> "value": 1 > > > >> >> >> >> } > > > >> >> >> >> } > > > >> >> >> >> } > > > >> >> >> >> ], > > > >> >> >> >> "rowkey": { > > > >> >> >> >> "rowkey_columns": [ > > > >> >> >> >> { > > > >> >> >> >> "column": "STOREID", > > > >> >> >> >> "length": 0, > > > >> >> >> >> "dictionary": "true", > > > >> >> >> >> "mandatory": false > > > >> >> >> >> }, > > > >> >> >> >> { > > > >> >> >> >> "column": "ITEMID", > > > >> >> >> >> "length": 0, > > > >> >> >> >> "dictionary": "true", > > > >> >> >> >> "mandatory": false > > > >> >> >> >> }, > > > >> >> >> >> { > > > >> >> >> >> "column": "CUSTID", > > > >> >> >> >> "length": 0, > > > >> >> >> >> "dictionary": "true", > > > >> >> >> >> "mandatory": false > > > >> >> >> >> } > > > >> >> >> >> ], > > > >> >> >> >> "aggregation_groups": [ > > > >> >> >> >> [ > > > >> >> >> >> "STOREID", > > > >> >> >> >> "ITEMID", > > > >> >> >> >> "CUSTID" > > > >> >> >> >> ] > > > >> >> >> >> ] > > > >> >> >> >> }, > > > >> >> >> >> "notify_list": [], > > > >> >> >> >> "capacity": "", > > > >> >> >> >> "hbase_mapping": { > > > >> >> >> >> "column_family": [ > > > >> >> >> >> { > > > >> >> >> >> "name": "f1", > > > >> >> >> >> "columns": [ > > > >> >> >> >> { > > > >> >> >> >> "qualifier": "m", > > > >> >> >> >> "measure_refs": [ > > > >> >> >> >> "_COUNT_" > > > >> >> >> >> ] > > > >> >> >> >> } > > > >> >> >> >> ] > > > >> >> >> >> } > > > >> >> >> >> ] > > > >> >> >> >> }, > > > >> >> >> >> "project": "RetailProject", > > > >> >> >> >> "model_name": "Retail_Cube" > > > >> >> >> >> } > > > >> >> >> >> > > > >> >> >> >>Regards, > > > >> >> >> >>Santosh Akhilesh > > > >> >> >> >>Bangalore R&D > > > >> >> >> >>HUAWEI TECHNOLOGIES CO.,LTD. > > > >> >> >> >> > > > >> >> >> >>www.huawei.com > > > >> >> >> >>---------------------------------------------------------- > > > >> >> >> --------------- > > > >> >> >> >>- > > > >> >> >> >>----------------------------------------------------------- > > > >> >> >> >>This e-mail and its attachments contain confidential > > information > > > >> >>from > > > >> >> >> >>HUAWEI, which > > > >> >> >> >>is intended only for the person or entity whose address is > > > >>listed > > > >> >> >>above. > > > >> >> >> >>Any use of the > > > >> >> >> >>information contained herein in any way (including, but not > > > >>limited > > > >> >> >>to, > > > >> >> >> >>total or partial > > > >> >> >> >>disclosure, reproduction, or dissemination) by persons other > > > >>than > > > >> >>the > > > >> >> >> >>intended > > > >> >> >> >>recipient(s) is prohibited. If you receive this e-mail in > > error, > > > >> >> >>please > > > >> >> >> >>notify the sender by > > > >> >> >> >>phone or email immediately and delete it! > > > >> >> >> >> > > > >> >> >> >>________________________________________ > > > >> >> >> >>From: Shi, Shaofeng [[email protected]] > > > >> >> >> >>Sent: Thursday, February 26, 2015 7:01 AM > > > >> >> >> >>To: [email protected] > > > >> >> >> >>Subject: Re: Error while making cube & Measure option is not > > > >> >> >>responding > > > >> >> >> >>on GUI > > > >> >> >> >> > > > >> >> >> >>Hi Santosh, > > > >> >> >> >> > > > >> >> >> >>It looks like hadoop failed to execute some shell command in > > the > > > >> >> >> >>container; You need dive into hadoop to see what¹s the > > concrete > > > >> >>error. > > > >> >> >> >>You > > > >> >> >> >>can use yarn logs command to fetch all logs: > > > >> >> >> >> > > > >> >> >> >>yarn logs -applicationId <app_id> > > > >> >> >> >> > > > >> >> >> >> > > > >> >> >> >>On 2/25/15, 7:39 PM, "Santosh Akhilesh" > > > >><[email protected] > > > >> > > > > >> >> >> >>wrote: > > > >> >> >> >> > > > >> >> >> >>>Hi Luke / Shaofeng , > > > >> >> >> >>> Can you please help me to check this issue. > > > >> >> >> >>>Regards, > > > >> >> >> >>>Santosh Akhilesh > > > >> >> >> >>> > > > >> >> >> >>>On Tue, Feb 24, 2015 at 10:41 PM, Santosh Akhilesh < > > > >> >> >> >>>[email protected]> wrote: > > > >> >> >> >>> > > > >> >> >> >>>> Hi All , > > > >> >> >> >>>> is it because of following error in map reduce > job > > ? > > > >> >>what > > > >> >> >> >>>>could > > > >> >> >> >>>>be > > > >> >> >> >>>> way to resolve this , a google search says that its issue > > of > > > >> >>Yarn > > > >> >> >> >>>>class > > > >> >> >> >>>> path , but I am not sure what it is ? > > > >> >> >> >>>> > > > >> >> >> >>>> Kylin Hive Column Cardinality Job table=RETAIL.FACT_SALES > > > >> >> >> >>>> output=/tmp/cardinality/RETAIL.FACT_SALES > > > >> >> >> >>>> > > > >> >> >> >>>> Application application_1424791969399_0008 failed 2 times > > due > > > >> >>to AM > > > >> >> >> >>>> Container for appattempt_1424791969399_0008_000002 exited > > > >>with > > > >> >> >> >>>>exitCode: 1 > > > >> >> >> >>>> For more detailed output, check application tracking > page: > > > >> >> >> >>>> > > > >>http://santosh:8088/proxy/application_1424791969399_0008/Then, > > > >> >> >>click > > > >> >> >> >>>>on > > > >> >> >> >>>> links to logs of each attempt. > > > >> >> >> >>>> Diagnostics: Exception from container-launch. > > > >> >> >> >>>> Container id: container_1424791969399_0008_02_000001 > > > >> >> >> >>>> Exit code: 1 > > > >> >> >> >>>> Stack trace: ExitCodeException exitCode=1: > > > >> >> >> >>>> at > org.apache.hadoop.util.Shell.runCommand(Shell.java:538) > > > >> >> >> >>>> at org.apache.hadoop.util.Shell.run(Shell.java:455) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>org.apache.hadoop.util.Shell$ShellCommandExecutor.execut > > > >> >> >> e(Shell.java:71 > > > >> >> >> >>>>5 > > > >> >> >> >>>>) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>org.apache.hadoop.yarn.server.nodemanager.DefaultContain > > > >> >> >> erExecutor.laun > > > >> >> >> >>>>c > > > >> >> >> >>>>h > > > >> >> >> >>>>Container(DefaultContainerExecutor.java:211) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>org.apache.hadoop.yarn.server.nodemanager.containermanag > > > >> >> >> er.launcher.Con > > > >> >> >> >>>>t > > > >> >> >> >>>>a > > > >> >> >> >>>>inerLaunch.call(ContainerLaunch.java:302) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>org.apache.hadoop.yarn.server.nodemanager.containermanag > > > >> >> >> er.launcher.Con > > > >> >> >> >>>>t > > > >> >> >> >>>>a > > > >> >> >> >>>>inerLaunch.call(ContainerLaunch.java:82) > > > >> >> >> >>>> at > java.util.concurrent.FutureTask.run(FutureTask.java:262) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>java.util.concurrent.ThreadPoolExecutor.runWorker(Thread > > > >> >> >> PoolExecutor.ja > > > >> >> >> >>>>v > > > >> >> >> >>>>a > > > >> >> >> >>>>:1145) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>java.util.concurrent.ThreadPoolExecutor$Worker.run(Threa > > > >> >> >> dPoolExecutor.j > > > >> >> >> >>>>a > > > >> >> >> >>>>v > > > >> >> >> >>>>a:615) > > > >> >> >> >>>> at java.lang.Thread.run(Thread.java:745) > > > >> >> >> >>>> Container exited with a non-zero exit code 1 > > > >> >> >> >>>> Failing this attempt. Failing the application. > > > >> >> >> >>>> > > > >> >> >> >>>> ---------- Forwarded message ---------- > > > >> >> >> >>>> From: Santoshakhilesh <[email protected]> > > > >> >> >> >>>> Date: Tue, Feb 24, 2015 at 7:41 PM > > > >> >> >> >>>> Subject: FW: Error while making cube & Measure option is > > not > > > >> >> >> >>>>responding > > > >> >> >> >>>>on > > > >> >> >> >>>> GUI > > > >> >> >> >>>> To: "[email protected]" > > > >> >> >><[email protected]> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> hi , > > > >> >> >> >>>> please someone give me a hand to resolve this issue , > > > >>thanks. > > > >> >> >> >>>> > > > >> >> >> >>>> Regards, > > > >> >> >> >>>> Santosh Akhilesh > > > >> >> >> >>>> Bangalore R&D > > > >> >> >> >>>> HUAWEI TECHNOLOGIES CO.,LTD. > > > >> >> >> >>>> > > > >> >> >> >>>> www.huawei.com > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>>-------------------------------------------------------- > > > >> >> >> --------------- > > > >> >> >> >>>>- > > > >> >> >> >>>>- > > > >> >> >> > >>>>------------------------------------------------------------ > > > >> >> >> >>>> This e-mail and its attachments contain confidential > > > >>information > > > >> >> >>from > > > >> >> >> >>>> HUAWEI, which > > > >> >> >> >>>> is intended only for the person or entity whose address > is > > > >> >>listed > > > >> >> >> >>>>above. > > > >> >> >> >>>> Any use of the > > > >> >> >> >>>> information contained herein in any way (including, but > not > > > >> >>limited > > > >> >> >> >>>>to, > > > >> >> >> >>>> total or partial > > > >> >> >> >>>> disclosure, reproduction, or dissemination) by persons > > other > > > >> >>than > > > >> >> >>the > > > >> >> >> >>>> intended > > > >> >> >> >>>> recipient(s) is prohibited. If you receive this e-mail in > > > >>error, > > > >> >> >> >>>>please > > > >> >> >> >>>> notify the sender by > > > >> >> >> >>>> phone or email immediately and delete it! > > > >> >> >> >>>> > > > >> >> >> >>>> ________________________________________ > > > >> >> >> >>>> From: Santoshakhilesh [[email protected]] > > > >> >> >> >>>> Sent: Tuesday, February 24, 2015 12:55 PM > > > >> >> >> >>>> To: [email protected] > > > >> >> >> >>>> Cc: Kulbhushan Rana > > > >> >> >> >>>> Subject: FW: Error while making cube & Measure option is > > not > > > >> >> >> >>>>responding > > > >> >> >> >>>>on > > > >> >> >> >>>> GUI > > > >> >> >> >>>> > > > >> >> >> >>>> 2. If I ignore and continue and try to save the cube I > get > > > >>an > > > >> >> >> >>>>exception > > > >> >> >> >>>> in Kylin.log , I have checked the path is set correctly > and > > > >> >> >> >>>>HCatInputFormat > > > >> >> >> >>>> this file is present in hive-hcatalog-core-0.14.0.jar . > > > >>Please > > > >> >>let > > > >> >> >>me > > > >> >> >> >>>>know > > > >> >> >> >>>> what can I do to resolve this ? > > > >> >> >> >>>> > > > >> >> >> >>>> -- This was path issue , now no more exception in > > kylin.log > > > >> >> >> >>>> > > > >> >> >> >>>> But saveing cube still fails with error. And still can't > > add > > > >> >> >>measures. > > > >> >> >> >>>> > > > >> >> >> >>>> Error Message > > > >> >> >> >>>> Failed to take action. > > > >> >> >> >>>> > > > >> >> >> >>>> In log I can find no exception. Following is the last log > > in > > > >> >> >>kylin.log > > > >> >> >> >>>> > > > >> >> >> >>>> [pool-3-thread-1]:[2015-02-24 > > > >> >> >> >>>> > > > >> >> >> >>>>20:47:15,613][INFO][org.apache.kylin.job.impl.threadpool > > > >> >> >> .DefaultSchedul > > > >> >> >> >>>>e > > > >> >> >> >>>>r > > > >> >> >> >>>>$FetcherRunner.run(DefaultScheduler.java:117)] > > > >> >> >> >>>> - Job Fetcher: 0 running, 0 actual running, 0 ready, 6 > > others > > > >> >> >> >>>> [http-bio-7070-exec-2]:[2015-02-24 > > > >> >> >> >>>> > > > >> >> >> >>>>20:47:51,610][DEBUG][org.apache.kylin.rest.controller.Cu > > > >> >> >> beController.de > > > >> >> >> >>>>s > > > >> >> >> >>>>e > > > >> >> >> >>>>rializeDataModelDesc(CubeController.java:459)] > > > >> >> >> >>>> - Saving cube { > > > >> >> >> >>>> "name": "", > > > >> >> >> >>>> "fact_table": "RETAIL.FACT_SALES", > > > >> >> >> >>>> "lookups": [], > > > >> >> >> >>>> "filter_condition": "", > > > >> >> >> >>>> "capacity": "SMALL", > > > >> >> >> >>>> "partition_desc": { > > > >> >> >> >>>> "partition_date_column": "", > > > >> >> >> >>>> "partition_date_start": 0, > > > >> >> >> >>>> "partition_type": "APPEND" > > > >> >> >> >>>> }, > > > >> >> >> >>>> "last_modified": 0 > > > >> >> >> >>>> } > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> local access logs all with 200 , so seems ok. > > > >> >> >> >>>> > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:46:56 +0800] "GET > > > >> >> >> >>>> /kylin/api/user/authentication HTTP/1.1" 200 246 > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:47:07 +0800] "GET > > > >> >> >> >>>> /kylin/api/user/authentication HTTP/1.1" 200 246 > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:47:27 +0800] "GET > > > >> >> >> >>>> /kylin/api/user/authentication HTTP/1.1" 200 246 > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:47:28 +0800] "GET > > > >> >> >> >>>> /kylin/api/user/authentication HTTP/1.1" 200 246 > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:47:34 +0800] "GET > > > >> >> >> >>>> /kylin/api/user/authentication HTTP/1.1" 200 246 > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:47:48 +0800] "GET > > > >> >> >> >>>> /kylin/api/user/authentication HTTP/1.1" 200 246 > > > >> >> >> >>>> 10.18.146.105 - - [24/Feb/2015:20:47:51 +0800] "POST > > > >> >> >>/kylin/api/cubes > > > >> >> >> >>>> HTTP/1.1" 200 701 > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> Regards, > > > >> >> >> >>>> Santosh Akhilesh > > > >> >> >> >>>> Bangalore R&D > > > >> >> >> >>>> HUAWEI TECHNOLOGIES CO.,LTD. > > > >> >> >> >>>> > > > >> >> >> >>>> www.huawei.com > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>>-------------------------------------------------------- > > > >> >> >> --------------- > > > >> >> >> >>>>- > > > >> >> >> >>>>- > > > >> >> >> > >>>>------------------------------------------------------------ > > > >> >> >> >>>> This e-mail and its attachments contain confidential > > > >>information > > > >> >> >>from > > > >> >> >> >>>> HUAWEI, which > > > >> >> >> >>>> is intended only for the person or entity whose address > is > > > >> >>listed > > > >> >> >> >>>>above. > > > >> >> >> >>>> Any use of the > > > >> >> >> >>>> information contained herein in any way (including, but > not > > > >> >>limited > > > >> >> >> >>>>to, > > > >> >> >> >>>> total or partial > > > >> >> >> >>>> disclosure, reproduction, or dissemination) by persons > > other > > > >> >>than > > > >> >> >>the > > > >> >> >> >>>> intended > > > >> >> >> >>>> recipient(s) is prohibited. If you receive this e-mail in > > > >>error, > > > >> >> >> >>>>please > > > >> >> >> >>>> notify the sender by > > > >> >> >> >>>> phone or email immediately and delete it! > > > >> >> >> >>>> > > > >> >> >> >>>> ________________________________________ > > > >> >> >> >>>> From: Santoshakhilesh [[email protected]] > > > >> >> >> >>>> Sent: Tuesday, February 24, 2015 12:09 PM > > > >> >> >> >>>> To: [email protected] > > > >> >> >> >>>> Cc: Kulbhushan Rana > > > >> >> >> >>>> Subject: Error while making cube & Measure option is not > > > >> >> >>responding on > > > >> >> >> >>>>GUI > > > >> >> >> >>>> > > > >> >> >> >>>> Hi All , > > > >> >> >> >>>> > > > >> >> >> >>>> I am building a simple cube for test and using the > > binary > > > >> >>build > > > >> >> >> >>>>0.7.1 > > > >> >> >> >>>> . I have following hive tables with columns. > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> fact_sales: > > > >> >> >> >>>> > > > >> >> >> >>>> storeid int > > > >> >> >> >>>> itemid int > > > >> >> >> >>>> custid int > > > >> >> >> >>>> qty int > > > >> >> >> >>>> price double > > > >> >> >> >>>> > > > >> >> >> >>>> dim_customer > > > >> >> >> >>>> custid int > > > >> >> >> >>>> name string > > > >> >> >> >>>> > > > >> >> >> >>>> dim_item > > > >> >> >> >>>> > > > >> >> >> >>>> itemid int > > > >> >> >> >>>> category string > > > >> >> >> >>>> brand string > > > >> >> >> >>>> color string > > > >> >> >> >>>> > > > >> >> >> >>>> dim_store > > > >> >> >> >>>> > > > >> >> >> >>>> storeid int > > > >> >> >> >>>> city string > > > >> >> >> >>>> state string > > > >> >> >> >>>> > > > >> >> >> >>>> Please help me to answer following issues; > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> 1. When I go to measure section and click on measure > > option , > > > >> >> >>there is > > > >> >> >> >>>>no > > > >> >> >> >>>> response , I want add measure on qty and price with sum > > > >> >> >> >>>> > > > >> >> >> >>>> 2. If I ignore and continue and try to save the cube I > get > > > >>an > > > >> >> >> >>>>exception > > > >> >> >> >>>> in Kylin.log , I have checked the path is set correctly > and > > > >> >> >> >>>>HCatInputFormat > > > >> >> >> >>>> this file is present in hive-hcatalog-core-0.14.0.jar . > > > >>Please > > > >> >>let > > > >> >> >>me > > > >> >> >> >>>>know > > > >> >> >> >>>> what can I do to resolve this ? > > > >> >> >> >>>> > > > >> >> >> >>>> 3. Also I have another question since this is a test and > > > >>data is > > > >> >> >>small > > > >> >> >> >>>>I > > > >> >> >> >>>> have not partitioned the fact table , is it ok to skip > > > >>partition > > > >> >> >>stage > > > >> >> >> >>>> while cube build ? > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> Exception > > > >> >> >> >>>> > > > >> >> >> >>>> pool-4-thread-4]:[2015-02-24 > > > >> >> >> >>>> > > > >> >> >> >>>>19:26:32,577][ERROR][org.apache.kylin.job.impl.threadpoo > > > >> >> >> l.DefaultSchedu > > > >> >> >> >>>>l > > > >> >> >> >>>>e > > > >> >> >> >>>>r$JobRunner.run(DefaultScheduler.java:134)] > > > >> >> >> >>>> - ExecuteException > job:c3532a6f-97ea-474a-b36a-218dd517cedb > > > >> >> >> >>>> org.apache.kylin.job.exception.ExecuteException: > > > >> >> >> >>>> org.apache.kylin.job.exception.ExecuteException: > > > >> >> >> >>>> java.lang.NoClassDefFoundError: > > > >> >> >> >>>> org/apache/hive/hcatalog/mapreduce/HCatInputFormat > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>org.apache.kylin.job.execution.AbstractExecutable.execut > > > >> >> >> e(AbstractExecu > > > >> >> >> >>>>t > > > >> >> >> >>>>a > > > >> >> >> >>>>ble.java:102) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>org.apache.kylin.job.impl.threadpool.DefaultScheduler$Jo > > > >> >> >> bRunner.run(Def > > > >> >> >> >>>>a > > > >> >> >> >>>>u > > > >> >> >> >>>>ltScheduler.java:132) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>java.util.concurrent.ThreadPoolExecutor.runWorker(Thread > > > >> >> >> PoolExecutor.ja > > > >> >> >> >>>>v > > > >> >> >> >>>>a > > > >> >> >> >>>>:1145) > > > >> >> >> >>>> at > > > >> >> >> >>>> > > > >> >> >> >>>>java.util.concurrent.ThreadPoolExecutor$Worker.run(Threa > > > >> >> >> dPoolExecutor.j > > > >> >> >> >>>>a > > > >> >> >> >>>>v > > > >> >> >> >>>>a:615) > > > >> >> >> >>>> at java.lang.Thread.run(Thread.java:745) > > > >> >> >> >>>> Caused by: > org.apache.kylin.job.exception.ExecuteException: > > > >> >> >> >>>> java.lang.NoClassDefFoundError: > > > >> >> >> >>>> org/apache/hive/hcatalog/mapreduce/HCatInputFormat > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> The JSON is as below. > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> { > > > >> >> >> >>>> "name": "Retail_Cube", > > > >> >> >> >>>> "description": "", > > > >> >> >> >>>> "dimensions": [ > > > >> >> >> >>>> { > > > >> >> >> >>>> "name": "RETAIL.FACT_SALES.STOREID", > > > >> >> >> >>>> "table": "RETAIL.FACT_SALES", > > > >> >> >> >>>> "hierarchy": false, > > > >> >> >> >>>> "derived": null, > > > >> >> >> >>>> "column": [ > > > >> >> >> >>>> "STOREID" > > > >> >> >> >>>> ], > > > >> >> >> >>>> "id": 1 > > > >> >> >> >>>> }, > > > >> >> >> >>>> { > > > >> >> >> >>>> "name": "RETAIL.FACT_SALES.ITEMID", > > > >> >> >> >>>> "table": "RETAIL.FACT_SALES", > > > >> >> >> >>>> "hierarchy": false, > > > >> >> >> >>>> "derived": null, > > > >> >> >> >>>> "column": [ > > > >> >> >> >>>> "ITEMID" > > > >> >> >> >>>> ], > > > >> >> >> >>>> "id": 2 > > > >> >> >> >>>> }, > > > >> >> >> >>>> { > > > >> >> >> >>>> "name": "RETAIL.FACT_SALES.CUSTID", > > > >> >> >> >>>> "table": "RETAIL.FACT_SALES", > > > >> >> >> >>>> "hierarchy": false, > > > >> >> >> >>>> "derived": null, > > > >> >> >> >>>> "column": [ > > > >> >> >> >>>> "CUSTID" > > > >> >> >> >>>> ], > > > >> >> >> >>>> "id": 3 > > > >> >> >> >>>> } > > > >> >> >> >>>> ], > > > >> >> >> >>>> "measures": [ > > > >> >> >> >>>> { > > > >> >> >> >>>> "id": 1, > > > >> >> >> >>>> "name": "_COUNT_", > > > >> >> >> >>>> "function": { > > > >> >> >> >>>> "expression": "COUNT", > > > >> >> >> >>>> "returntype": "bigint", > > > >> >> >> >>>> "parameter": { > > > >> >> >> >>>> "type": "constant", > > > >> >> >> >>>> "value": 1 > > > >> >> >> >>>> } > > > >> >> >> >>>> } > > > >> >> >> >>>> } > > > >> >> >> >>>> ], > > > >> >> >> >>>> "rowkey": { > > > >> >> >> >>>> "rowkey_columns": [ > > > >> >> >> >>>> { > > > >> >> >> >>>> "column": "STOREID", > > > >> >> >> >>>> "length": 0, > > > >> >> >> >>>> "dictionary": "true", > > > >> >> >> >>>> "mandatory": false > > > >> >> >> >>>> }, > > > >> >> >> >>>> { > > > >> >> >> >>>> "column": "ITEMID", > > > >> >> >> >>>> "length": 0, > > > >> >> >> >>>> "dictionary": "true", > > > >> >> >> >>>> "mandatory": false > > > >> >> >> >>>> }, > > > >> >> >> >>>> { > > > >> >> >> >>>> "column": "CUSTID", > > > >> >> >> >>>> "length": 0, > > > >> >> >> >>>> "dictionary": "true", > > > >> >> >> >>>> "mandatory": false > > > >> >> >> >>>> } > > > >> >> >> >>>> ], > > > >> >> >> >>>> "aggregation_groups": [ > > > >> >> >> >>>> [ > > > >> >> >> >>>> "STOREID", > > > >> >> >> >>>> "ITEMID", > > > >> >> >> >>>> "CUSTID" > > > >> >> >> >>>> ] > > > >> >> >> >>>> ] > > > >> >> >> >>>> }, > > > >> >> >> >>>> "notify_list": [], > > > >> >> >> >>>> "capacity": "", > > > >> >> >> >>>> "hbase_mapping": { > > > >> >> >> >>>> "column_family": [ > > > >> >> >> >>>> { > > > >> >> >> >>>> "name": "f1", > > > >> >> >> >>>> "columns": [ > > > >> >> >> >>>> { > > > >> >> >> >>>> "qualifier": "m", > > > >> >> >> >>>> "measure_refs": [ > > > >> >> >> >>>> "_COUNT_" > > > >> >> >> >>>> ] > > > >> >> >> >>>> } > > > >> >> >> >>>> ] > > > >> >> >> >>>> } > > > >> >> >> >>>> ] > > > >> >> >> >>>> }, > > > >> >> >> >>>> "project": "RetailProject", > > > >> >> >> >>>> "model_name": "Retail_Cube" > > > >> >> >> >>>> } > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> Regards, > > > >> >> >> >>>> Santosh Akhilesh > > > >> >> >> >>>> Bangalore R&D > > > >> >> >> >>>> HUAWEI TECHNOLOGIES CO.,LTD. > > > >> >> >> >>>> > > > >> >> >> >>>> www.huawei.com > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>>-------------------------------------------------------- > > > >> >> >> --------------- > > > >> >> >> >>>>- > > > >> >> >> >>>>- > > > >> >> >> > >>>>------------------------------------------------------------ > > > >> >> >> >>>> This e-mail and its attachments contain confidential > > > >>information > > > >> >> >>from > > > >> >> >> >>>> HUAWEI, which > > > >> >> >> >>>> is intended only for the person or entity whose address > is > > > >> >>listed > > > >> >> >> >>>>above. > > > >> >> >> >>>> Any use of the > > > >> >> >> >>>> information contained herein in any way (including, but > not > > > >> >>limited > > > >> >> >> >>>>to, > > > >> >> >> >>>> total or partial > > > >> >> >> >>>> disclosure, reproduction, or dissemination) by persons > > other > > > >> >>than > > > >> >> >>the > > > >> >> >> >>>> intended > > > >> >> >> >>>> recipient(s) is prohibited. If you receive this e-mail in > > > >>error, > > > >> >> >> >>>>please > > > >> >> >> >>>> notify the sender by > > > >> >> >> >>>> phone or email immediately and delete it! > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> > > > >> >> >> >>>> -- > > > >> >> >> >>>> Regards, > > > >> >> >> >>>> Santosh Akhilesh > > > >> >> >> >>>> +91-0-9845482201 > > > >> >> >> >>>> > > > >> >> >> >>> > > > >> >> >> >>> > > > >> >> >> >>> > > > >> >> >> >>>-- > > > >> >> >> >>>Regards, > > > >> >> >> >>>Santosh Akhilesh > > > >> >> >> >>>+91-0-9845482201 > > > >> >> >> > > > >> >> >> > > > >> >> > > > >> >> > > > >> > > > >> > > > > > > > > > > > > -- > > Regards, > > Santosh Akhilesh > > +91-0-9845482201 > > > -- Regards, Santosh Akhilesh +91-0-9845482201
