Awesome!
I tried this and it solved my issue. I now the the table / database and can
query the cube with second latency, thanks a lot!
Just one thing, the source and destination are actually reversed, here are
the commands:
cp tomcat/webapps/kylin/WEB-INF/lib/calcite-core-${version}.jar tomcat/lib/
cp tomcat/webapps/kylin/WEB-INF/lib/kylin-query-${version}.jar tomcat/lib/
On Fri, Jun 5, 2015 at 11:47 AM, divye sheth <[email protected]> wrote:
> Hi Alex,
>
> I had faced the same issue and I believe it was addressed by one of the
> developers of Kylin, cant get hold of the link though. Here is the solution
> that was posted there and I was able to get this working.
>
> Copy the kylin-query-${version}.jar and calcite-core-${version}.jar the
> source and destination are given below:
> sourcce location: $KYLIN_HOME/tomcat/lib
> destination: $KYLIN_HOME/tomcat/webapps/kylin/WEB-INF/lib
>
> after you have copied please restart the kylin. Let me know if this solves
> your issue.
>
> Thanks
> Divye Sheth
>
> On Fri, Jun 5, 2015 at 4:04 PM, alex schufo <[email protected]> wrote:
>
> > I checked that but there isn't any dependency error, see below the
> output:
> >
> > $ bin/check-env.sh
> >
> > KYLIN_HOME is set to /home/username/kylin/kylin-0.7.1-incubating-SNAPSHOT
> >
> > On Fri, Jun 5, 2015 at 11:16 AM, Shi, Shaofeng <[email protected]> wrote:
> >
> > > Please run $KYLIN_HOME/bin/find-hive-dependency.sh and then copy the
> > > output here; Kylin need add the Hcatalog to MR class path, if the
> > Hcatalog
> > > jar wasn¹t found, the "HCatInputFormat not found² error will be
> reported;
> > >
> > > On 6/5/15, 4:58 PM, "alex schufo" <[email protected]> wrote:
> > >
> > > >Hi all,
> > > >
> > > >I built a cube on a Hive fact table of about 300 millions rows, all
> the
> > > >steps are FINISHED with success but it seems I cannot do any query.
> > > >
> > > >select * from myFactTable; (or any other query)
> > > >
> > > >returns From line 1, column 15 to line 1, column 43: Table
> 'MYFACTTABLE'
> > > >not found while executing SQL: "select * from myFactTable LIMIT 50000"
> > > >
> > > >I tried rebuilding completely the cube after a purge, created a new
> > > >project, etc. but it doesn't solve the issue.
> > > >
> > > >It seems like a new KYLIN_ table has been created and contains data.
> How
> > > >can I know which HBase table corresponds to which cube?
> > > >
> > > >The "Convert Cuboid Data to HFile" step took a while, the MapReduce
> job
> > > >stayed in Undefined status for a long time but finally Succeeded.
> When I
> > > >click on the link from the Kylin UI it send me to 7070/kylin/N/A
> instead
> > > >of
> > > >the MapReduce job info, is that a bad sign?
> > > >
> > > >In the logs I don't see any error in the Build N-Dimension Cuboid
> Data,
> > > >Calculate HTable Region Splits, Create HTable
> > > >
> > > >I am not sure if it's event related but in the logs can this:
> > > >
> > > >2015-06-04 10:17:10,910 INFO [pool-7-thread-10] mapreduce.Job: map
> 1%
> > > >reduce 0%
> > > >
> > > >2015-06-04 10:17:11,936 INFO [pool-7-thread-10] mapreduce.Job: Task
> Id
> > :
> > > >attempt_1432057232815_49758_m_000003_2, Status : FAILED
> > > >
> > > >Error: java.lang.RuntimeException: java.lang.ClassNotFoundException:
> > Class
> > > >org.apache.hive.hcatalog.mapreduce.HCatInputFormat not found
> > > >
> > > > at
> > > >org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1961)
> > > >
> > > > at
> > >
> >
> >org.apache.hadoop.mapreduce.task.JobContextImpl.getInputFormatClass(JobCon
> > > >textImpl.java:174)
> > > >
> > > > at
> > org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:726)
> > > >
> > > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)
> > > >
> > > > at
> org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
> > > >
> > > > at java.security.AccessController.doPrivileged(Native Method)
> > > >
> > > > at javax.security.auth.Subject.doAs(Subject.java:415)
> > > >
> > > > at
> > >
> >
> >org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.
> > > >java:1594)
> > > >
> > > > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)
> > > >
> > > >Caused by: java.lang.ClassNotFoundException: Class
> > > >org.apache.hive.hcatalog.mapreduce.HCatInputFormat not found
> > > >
> > > > at
> > >
> >
> >org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:186
> > > >7)
> > > >
> > > > at
> > > >org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1959)
> > > >
> > > > ... 8 more
> > > >
> > > >
> > > >
> > > >but then it seems to go on anyway:
> > > >
> > > >2015-06-04 10:17:15,127 INFO [pool-7-thread-10] mapreduce.Job: map
> 2%
> > > >reduce 0%
> > > >
> > > >2015-06-04 10:17:18,174 INFO [pool-7-thread-10] mapreduce.Job: map
> 3%
> > > >reduce 0%
> > > >
> > > >2015-06-04 10:17:20,202 INFO [pool-7-thread-10] mapreduce.Job: map
> 4%
> > > >reduce 0%
> > > >
> > > >2015-06-04 10:17:22,230 INFO [pool-7-thread-10] mapreduce.Job: map
> 5%
> > > >reduce 0%
> > > >
> > > >2015-06-04 10:17:23,244 INFO [pool-7-thread-10] mapreduce.Job: map
> 6%
> > > >reduce 0%
> > > >
> > > >...
> > > >
> > > >2015-06-04 10:19:33,458 INFO [pool-7-thread-10] mapreduce.Job: map
> > 100%
> > > >reduce 100%
> > > >
> > > >2015-06-04 10:19:33,481 INFO [pool-7-thread-10] mapreduce.Job: Job
> > > >job_1432057232815_49758 completed successfully
> > > >
> > > >
> > > >This comes after
> > > >
> > > >
> > > >Hive Column Cardinality calculation for table
> > > >
> > > >and a step called :
> > > >
> > > >
> > >
> >
> >+-------------------------------------------------------------------------
> > > >-----------------------------+
> > > >
> > > >| null
> > > > |
> > > >
> > >
> >
> >+-------------------------------------------------------------------------
> > > >-----------------------------+
> > > >
> > > >
> > > >Thanks for your help, I would really like to make this PoC work!
> > >
> > >
> >
>
