Hi ,
I have set the conf path in start_kylin.sh as below. I have removed the
sourcing of find-hive-dependency.sh as its not working in my env.
In the hive-site.xml , I have set following; still i get same error , is
there anything else I need to do ?
<configuration>
<property>
<name>hive.exec.scratchdir</name>
<value>/tmp/hive</value>
<description>Scratch space for Hive jobs</description>
</property>
</configuration>
#source ${dir}/find-hive-dependency.sh
export
hive_dependency=/home/santosh/work/frameworks/apache-hive-1.0.0/conf/:/home/santosh/work/frameworks/apache-hive-1.0.0/lib/*:/home/santosh/work/frameworks/apache-hive-1.0.0/hcatalog/share/hcatalog/*
export
HBASE_CLASSPATH_PREFIX=${tomcat_root}/bin/bootstrap.jar:${tomcat_root}/bin/tomcat-juli.jar:${tomcat_root}/lib/*:$HBASE_CLASSPATH_PREFIX
export HBASE_CLASSPATH=$hive_dependency:${HBASE_CLASSPATH}
hbase
-Djava.util.logging.config.file=${tomcat_root}/conf/logging.properties \
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager \
-Dorg.apache.tomcat.util.buf.UDecoder.ALLOW_ENCODED_SLASH=true \
-Dorg.apache.catalina.connector.CoyoteAdapter.ALLOW_BACKSLASH=true \
-Djava.endorsed.dirs=${tomcat_root}/endorsed \
-Dcatalina.base=${tomcat_root} \
-Dcatalina.home=${tomcat_root} \
-Djava.io.tmpdir=${tomcat_root}/temp \
-Dkylin.hive.dependency=${hive_dependency} \
-Dspring.profiles.active=${spring_profile} \
org.apache.hadoop.util.RunJar ${tomcat_root}/bin/bootstrap.jar
org.apache.catalina.startup.Bootstrap start >
${tomcat_root}/logs/kylin.log 2>&1 &
echo "A new Kylin instance is started by $USER, stop it using
\"stop-kylin.sh\""
if [ "$useSandbox" = "true" ]
then echo "Please visit http://<your_sandbox_ip>:7070/kylin to play
with the cubes! (Useranme: ADMIN, Password: KYLIN)"
else
echo "Please visit http://<ip>:7070/kylin"
fi
echo "You can check the log at ${tomcat_root}/logs/kylin.log"
On Fri, Feb 20, 2015 at 8:10 PM, Shi, Shaofeng <[email protected]> wrote:
> Hi,
>
> Kylin from 7.0.x and later needs hive-site.xml on the classpth, to allow
> Kylin connect with the hive metadata service via API, to get the table
> info; As you can execute hive commands on your machine, the hive client
> should have been properly set, you can search the hive-site.xml from / to
> get its path, and then add it to the script as Qianhao mentioned.
>
> On 2/20/15, 10:28 PM, "Santosh Akhilesh" <[email protected]>
> wrote:
>
> >Hi Qianhao,
> > I really wonder what kind of config I need to set for making sure
> >kylin can load the hive tables.
> > I am not using the ready made sandbox , I have downloaded hbase ,
> >hive , hadoop from apcahe site to make the env. As far as I can see
> >currently I can query hive tables in hive shell. Mine is single node
> >pseudo
> >distributed cluster. I have not set any changes to hive-site.xml , the
> >metastoredb is created under $HIVE_INSTALL/bin
> >data is on hdfs under /user/hive/warehouse.
> >
> >I am really out of clue why the exception , I suspect its some setting
> >which kylin expects to make hive query run
> >
> >Please help me to get over this issue , thanks.
> >2015-02-20 19:38:10,435 INFO [http-bio-7070-exec-3] HiveMetaStore.audit:
> >ugi=santosh ip=unknown-ip-addr cmd=get_table : db=DEFAULT tbl=books
> >NoSuchObjectException(message:DEFAULT.books table not found)
> >at
> >org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table_core(H
> >iveMetaStore.java:1729)
> >at
> >org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMe
> >taStore.java:1699)
> >at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >at
> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> >57)
> >at
> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
> >pl.java:43)
> >at java.lang.reflect.Method.invoke(Method.java:606)
> >at
> >org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHand
> >ler.java:102)
> >at com.sun.proxy.$Proxy37.get_table(Unknown Source)
> >at
> >org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStor
> >eClient.java:1097)
> >at
> >org.apache.kylin.common.util.HiveClient.getHiveTable(HiveClient.java:115)
> >at
> >org.apache.kylin.metadata.tool.HiveSourceTableLoader.extractHiveTables(Hiv
> >eSourceTableLoader.java:86)
> >
> >On Fri, Feb 20, 2015 at 4:53 PM, Santosh Akhilesh
> ><[email protected]
> >> wrote:
> >
> >> Hi Qianhao,
> >> *I have installed hive from Apache hive site. I dont have following
> >> folder. *
> >> /usr/hdp/current/hive-client/conf/ in this script.
> >> *I am using Hive 1.0.0 version.*
> >> *Where can I get this ? and which conf files I need to set under conf
> >> folder ?*
> >> *Regards,*
> >> *Santosh Akhilesh*
> >>
> >>
> >>
> >>
> >> On Fri, Feb 20, 2015 at 10:51 AM, 周千昊 <[email protected]> wrote:
> >>
> >>> Hi, Santosh
> >>> Thanks for reporting the issue, it looks to me that it is still
> >>>the
> >>> problem of find-hive-dependecny.sh.
> >>> As a workaround, you can just manually add
> >>> /usr/hdp/current/hive-client/conf/ in this script.
> >>>
> >>> On Thu Feb 19 2015 at 8:01:39 PM Santoshakhilesh <
> >>> [email protected]> wrote:
> >>>
> >>> > Hi ,
> >>> > I analyzed the Kylin.log and found that find-hive-dependency.sh
> >>>was
> >>> > not able to locate hive installation path correctly , so I modified
> >>>the
> >>> > script to set the correct hive lib path.
> >>> > Now I dont get no classs found error so it means that class path
> >>>is
> >>> > set right now to resolve hive dependencies.
> >>> >
> >>> > The next exception I get is following ,
> >>> > NoSuchObjectException(message:DEFAULT.books table not found)
> >>> >
> >>> > I could run following query on hive console;
> >>> > select * from default.books;
> >>> >
> >>> > So again problem seems to be some settings related to hive , can
> >>>someone
> >>> > help me locate this issue ?
> >>> > Also I want to know do I need to include following lib; I dont have
> >>>it
> >>> > currently in my path
> >>> > /usr/hdp/current/hive-client/conf/
> >>> >
> >>> > Exception:
> >>> > 2015-02-20 01:15:18,163 INFO [http-bio-7070-exec-10]
> >>> > DataNucleus.Datastore: The class
> >>> "org.apache.hadoop.hive.metastore.model.MFieldSchema"
> >>> > is tagged as "embedded-only" so does not have its own datastore
> >>>table.
> >>> > 2015-02-20 01:15:18,163 INFO [http-bio-7070-exec-10]
> >>> > DataNucleus.Datastore: The class
> >>> "org.apache.hadoop.hive.metastore.model.MOrder"
> >>> > is tagged as "embedded-only" so does not have its own datastore
> >>>table.
> >>> > 2015-02-20 01:15:18,532 INFO [http-bio-7070-exec-10]
> >>> > DataNucleus.Datastore: The class
> >>> "org.apache.hadoop.hive.metastore.model.MFieldSchema"
> >>> > is tagged as "embedded-only" so does not have its own datastore
> >>>table.
> >>> > 2015-02-20 01:15:18,532 INFO [http-bio-7070-exec-10]
> >>> > DataNucleus.Datastore: The class
> >>> "org.apache.hadoop.hive.metastore.model.MOrder"
> >>> > is tagged as "embedded-only" so does not have its own datastore
> >>>table.
> >>> > 2015-02-20 01:15:18,710 INFO [http-bio-7070-exec-10]
> >>>DataNucleus.Query:
> >>> > Reading in results for query
> >>> "org.datanucleus.store.rdbms.query.SQLQuery@0"
> >>> > since the connection used is closing
> >>> > 2015-02-20 01:15:18,713 INFO [http-bio-7070-exec-10]
> >>> > metastore.ObjectStore: Initialized ObjectStore
> >>> > 2015-02-20 01:15:19,002 INFO [http-bio-7070-exec-10]
> >>> > metastore.HiveMetaStore: Added admin role in metastore
> >>> > 2015-02-20 01:15:19,004 INFO [http-bio-7070-exec-10]
> >>> > metastore.HiveMetaStore: Added public role in metastore
> >>> > 2015-02-20 01:15:19,090 INFO [http-bio-7070-exec-10]
> >>> > metastore.HiveMetaStore: No user is added in admin role, since
> >>>config is
> >>> > empty
> >>> > 2015-02-20 01:15:19,213 INFO [http-bio-7070-exec-10]
> >>> > metastore.HiveMetaStore: 0: get_table : db=DEFAULT tbl=books
> >>> > 2015-02-20 01:15:19,213 INFO [http-bio-7070-exec-10]
> >>> HiveMetaStore.audit:
> >>> > ugi=root ip=unknown-ip-addr cmd=get_table : db=DEFAULT tbl=books
> >>> > NoSuchObjectException(message:DEFAULT.books table not found)
> >>> > at org.apache.hadoop.hive.metastore.HiveMetaStore$
> >>> > HMSHandler.get_table_core(HiveMetaStore.java:1729)
> >>> > at
> >>>org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(
> >>> > HiveMetaStore.java:1699)
> >>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>> > at sun.reflect.NativeMethodAccessorImpl.invoke(
> >>> > NativeMethodAccessorImpl.java:57)
> >>> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> >>> > DelegatingMethodAccessorImpl.java:43)
> >>> > at java.lang.reflect.Method.invoke(Method.java:606)
> >>> > at org.apache.hadoop.hive.metastore.RetryingHMSHandler.
> >>> > invoke(RetryingHMSHandler.java:102)
> >>> > at com.sun.proxy.$Proxy37.get_table(Unknown Source)
> >>> > at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.
> >>> > getTable(HiveMetaStoreClient.java:1091)
> >>> > at org.apache.kylin.common.util.HiveClient.getHiveTable(
> >>> > HiveClient.java:115)
> >>> > at org.apache.kylin.metadata.tool.HiveSourceTableLoader.
> >>> > extractHiveTables(HiveSourceTableLoader.java:86)
> >>> > at
> >>> org.apache.kylin.metadata.tool.HiveSourceTableLoader.reloadHiveTables(
> >>> > HiveSourceTableLoader.java:70)
> >>> > at org.apache.kylin.rest.service.CubeService.reloadHiveTable(
> >>> > CubeService.java:537)
> >>> > at org.apache.kylin.rest.service.CubeService$$FastClassByCGLIB$
> >>> > $17a07c0e.invoke(<generated>)
> >>> >
> >>> >
> >>> > 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: Thursday, February 19, 2015 3:37 PM
> >>> > To: [email protected]
> >>> > Subject: RE: Hive Table is not loaded in Kylin//RE: About building
> >>>kylin
> >>> >
> >>> > Looks like this is the issue , I find one exception in
> >>> > localhost.2015-02-19.log
> >>> >
> >>> >
> >>> > Does this mean there is some issue in hive version I use , I am using
> >>> > 0.14.0?
> >>> >
> >>> >
> >>> > SEVERE: Servlet.service() for servlet [kylin] in context with path
> >>> > [/kylin] threw exception [Handler processing failed; nested
> >>>exception is
> >>> > java.lang.NoClassDefFoundError:
> >>> org/apache/hadoop/hive/ql/session/SessionState]
> >>> > with root cause
> >>> > java.lang.ClassNotFoundException: org.apache.hadoop.hive.ql.
> >>> > session.SessionState
> >>> > at org.apache.catalina.loader.WebappClassLoader.loadClass(
> >>> > WebappClassLoader.java:1720)
> >>> > at org.apache.catalina.loader.WebappClassLoader.loadClass(
> >>> > WebappClassLoader.java:1571)
> >>> > at org.apache.kylin.metadata.tool.HiveSourceTableLoader.
> >>> > extractHiveTables(HiveSourceTableLoader.java:83)
> >>> > at
> >>> org.apache.kylin.metadata.tool.HiveSourceTableLoader.reloadHiveTables(
> >>> > HiveSourceTableLoader.java:70)
> >>> > at org.apache.kylin.rest.service.CubeService.reloadHiveTable(
> >>> > CubeService.java:537)
> >>> > at org.apache.kylin.rest.service.CubeService$$FastClassByCGLIB$
> >>> > $17a07c0e.invoke(<generated>)
> >>> > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> >>> >
> >>> > 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: Thursday, February 19, 2015 1:27 PM
> >>> > To: [email protected]
> >>> > Cc: Kulbhushan Rana
> >>> > Subject: Hive Table is not loaded in Kylin//RE: About building kylin
> >>> >
> >>> > Hi ,
> >>> >
> >>> > I have resolved this issue. I have hivesingle column table and I
> >>>can
> >>> > access from Hive console and do queries on it sucecssfully using hive
> >>> > console.
> >>> >
> >>> > When I try to synch hive table using Kylin web specifiying the
> >>>hive
> >>> > table name and synch.
> >>> >
> >>> > I get an error dialog "Oops Failed to take action" .
> >>> >
> >>> >
> >>> >
> >>> > Kylin.log
> >>> >
> >>> >
> >>> > [pool-3-thread-1]:[2015-02-19 21:09:54,152][INFO][org.
> >>> >
> >>>
> >>>apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(Defa
> >>>ultScheduler.java:117)]
> >>> > - Job Fetcher: 0 running, 0 actual running, 0 ready, 0 others
> >>> > [http-bio-7070-exec-4]:[2015-02-19 21:09:59,556][INFO][org.
> >>> >
> >>>
> >>>apache.kylin.rest.controller.TableController.getHiveTables(TableControll
> >>>er.java:74)]
> >>> > - Return all table metadata in 0 seconds
> >>> >
> >>> >
> >>> >
> >>> > localhost_access_log.2015-02-19.txt
> >>> >
> >>> >
> >>> >
> >>> > 10.19.36.67 - - [19/Feb/2015:21:21:58 +0800] "POST
> >>> > /kylin/api/tables/books/Sample HTTP/1.1" 500 1972
> >>> >
> >>> >
> >>> >
> >>> > Here books is my table (I have used default database) and sample is
> >>>name
> >>> > of my project
> >>> >
> >>> >
> >>> >
> >>> > What could be reason of not loading the hive tables ? Someone whi is
> >>> able
> >>> > to load the hive table successfully can help me to debug this issue ?
> >>> >
> >>> >
> >>> >
> >>> > 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: Santosh Akhilesh [[email protected]]
> >>> > Sent: Tuesday, February 17, 2015 8:13 PM
> >>> > To: [email protected]
> >>> > Subject: Re: About building kylin
> >>> >
> >>> > Hi,
> >>> > These days I spent time to learn Hive and create tables required
> >>> for
> >>> > my test.
> >>> > Unfortunately when I am all set with Hive tables , Kylin can't
> >>> start
> >>> > normally. Before this I could start and login to web ui. the logs are
> >>> like
> >>> > below. What has gone wring any idea ?
> >>> >
> >>> > SLF4J: Class path contains multiple SLF4J bindings.
> >>> > SLF4J: Found binding in [jar:file:/home/santosh/work/
> >>> > frameworks/hbase-0.98.10-hadoop2/lib/slf4j-log4j12-1.6.
> >>> > 4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> >>> > SLF4J: Found binding in [jar:file:/home/santosh/work/
> >>> > frameworks/hadoop-1.2.1/lib/slf4j-log4j12-1.4.3.jar!/org/
> >>> > slf4j/impl/StaticLoggerBinder.class]
> >>> > SLF4J: Found binding in [jar:file:/home/santosh/work/
> >>> > frameworks/kylin/tomcat/webapps/kylin/WEB-INF/lib/
> >>> > slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> >>> > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> >>> > explanation.
> >>> > [localhost-startStop-1]:[2015-02-17 19:57:41,307][WARN][org.
> >>> >
> >>>
> >>>apache.kylin.common.KylinConfig.getKylinProperties(KylinConfig.java:527)
> >>>]
> >>> > - KYLIN_CONF_HOME has not been set
> >>> > [localhost-startStop-1]:[2015-02-17 19:57:41,419][INFO][org.
> >>> >
> >>>springframework.core.io.support.PropertiesLoaderSupport.loadProperties(
> >>> > PropertiesLoaderSupport.java:177)] - Loading properties file from
> >>> > resource loaded through InputStream
> >>> > [localhost-startStop-1]:[2015-02-17 19:57:41,815][WARN][org.
> >>> >
> >>>
> >>>apache.kylin.common.KylinConfig.getKylinProperties(KylinConfig.java:527)
> >>>]
> >>> > - KYLIN_CONF_HOME has not been set
> >>> > SLF4J: Class path contains multiple SLF4J bindings.
> >>> > SLF4J: Found binding in [jar:file:/home/santosh/work/
> >>> > frameworks/hbase-0.98.10-hadoop2/lib/slf4j-log4j12-1.6.
> >>> > 4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> >>> > SLF4J: Found binding in [jar:file:/home/santosh/work/
> >>> > frameworks/hadoop-1.2.1/lib/slf4j-log4j12-1.4.3.jar!/org/
> >>> > slf4j/impl/StaticLoggerBinder.class]
> >>> > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> >>> > explanation.
> >>> > [localhost-startStop-1]:[2015-02-17 19:57:43,051][ERROR][org.
> >>> >
> >>>
> >>>springframework.web.context.ContextLoader.initWebApplicationContext(Cont
> >>>extLoader.java:307)]
> >>> > - Context initialization failed
> >>> > org.springframework.beans.factory.BeanCreationException: Error
> >>>creating
> >>> > bean with name 'com.ryantenney.metrics.spring.
> >>> > MetricsBeanPostProcessorFactory#0': BeanPostProcessor before
> >>> > instantiation of bean failed; nested exception is
> >>> org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name
> >>> 'org.springframework.cache.config.internalCacheAdvisor':
> >>> > Cannot resolve reference to bean
> >>>'org.springframework.cache.annotation.
> >>> > AnnotationCacheOperationSource#0' while setting bean property
> >>> > 'cacheOperationSource'; nested exception is
> >>> org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name 'org.springframework.cache.annotation.
> >>> > AnnotationCacheOperationSource#0': BeanPostProcessor before
> >>> instantiation
> >>> > of bean failed; nested exception is
> >>> org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name 'org.springframework.security.
> >>> > methodSecurityMetadataSourceAdvisor': Cannot resolve reference to
> >>>bean
> >>> >
> >>>
> >>>'org.springframework.security.access.method.DelegatingMethodSecurityMeta
> >>>dataSource#0'
> >>> > while setting constructor argument; nested exception is
> >>> > org.springframework.beans.factory.BeanCreationException: Error
> >>>creating
> >>> > bean with name 'org.springframework.security.access.method.
> >>> > DelegatingMethodSecurityMetadataSource#0': Cannot create inner bean
> >>> > '(inner bean)' of type [org.springframework.security.access.prepost.
> >>> > PrePostAnnotationSecurityMetadataSource] while setting constructor
> >>> > argument with key [0]; nested exception is
> >>> org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name '(inner bean)': Cannot create inner
> >>>bean
> >>> > '(inner bean)' of type [org.springframework.security.
> >>> > access.expression.method.ExpressionBasedAnnotationAttributeFactory]
> >>> while
> >>> > setting constructor argument; nested exception is
> >>> org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name '(inner bean)': Cannot resolve
> >>>reference
> >>> to
> >>> > bean 'expressionHandler' while setting constructor argument; nested
> >>> > exception is org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name 'expressionHandler' defined in class
> >>>path
> >>> > resource [kylinSecurity.xml]: Cannot resolve reference to bean
> >>> > 'permissionEvaluator' while setting bean property
> >>>'permissionEvaluator';
> >>> > nested exception is
> >>> org.springframework.beans.factory.BeanCreationException:
> >>> > Error creating bean with name 'permissionEvaluator' defined in class
> >>> path
> >>> > resource [kylinSecurity.xml]: Cannot resolve reference to bean
> >>> 'aclService'
> >>> > while setting constructor argument; nested exception is
> >>> > org.springframework.beans.factory.BeanCreationException: Error
> >>>creating
> >>> > bean with name 'aclService' defined in file [/home/santosh/work/
> >>> > frameworks/kylin/tomcat/webapps/kylin/WEB-INF/classes/
> >>> > org/apache/kylin/rest/service/AclService.class]: Instantiation of
> >>>bean
> >>> > failed; nested exception is
> >>> org.springframework.beans.BeanInstantiationException:
> >>> > Could not instantiate bean class
> >>> [org.apache.kylin.rest.service.AclService]:
> >>> > Constructor threw exception; nested exception is
> >>> org.apache.kylin.common.persistence.StorageException:
> >>> > Error when open connection hbase
> >>> > at org.springframework.beans.factory.support.
> >>> > AbstractAutowireCapableBeanFactory.createBean(
> >>> > AbstractAutowireCapableBeanFactory.java:452)
> >>> > at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> >>> > getObject(AbstractBeanFactory.java:294)
> >>> > at
> >>> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> >>> > getSingleton(DefaultSingletonBeanRegistry.java:225)
> >>> > at org.springframework.beans.factory.support.
> >>> > AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
> >>> > at
> >>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> >>> > AbstractBeanFactory.java:197)
> >>> > at org.springframework.context.support.AbstractApplicationContext.
> >>> > registerBeanPostProcessors(AbstractApplicationContext.java:745)
> >>> > at
> >>> org.springframework.context.support.AbstractApplicationContext.refresh(
> >>> > AbstractApplicationContext.java:454)
> >>> > at org.springframework.web.context.ContextLoader.
> >>> > configureAndRefreshWebApplicationContext(ContextLoader.java:383)
> >>> > at org.springframework.web.context.ContextLoader.
> >>> > initWebApplicationContext(ContextLoader.java:283)
> >>> > at org.springframework.web.context.ContextLoaderListener.
> >>> > contextInitialized(ContextLoaderListener.java:111)
> >>> > at org.apache.catalina.core.StandardContext.listenerStart(
> >>> > StandardContext.java:5016)
> >>> > at org.apache.catalina.core.StandardContext.startInternal(
> >>> > StandardContext.java:5524)
> >>> > at
> >>>org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
> >>> > at org.apache.catalina.core.ContainerBase.addChildInternal(
> >>> > ContainerBase.java:901)
> >>> > at
> >>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
> >>> > at
> >>>org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
> >>> > at
> >>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1081)
> >>> > at org.apache.catalina.startup.HostConfig$DeployWar.run(
> >>> > HostConfig.java:1877)
> >>> > at
> >>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> >>> > at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> >>> > at java.util.concurrent.ThreadPoolExecutor.runWorker(
> >>> > ThreadPoolExecutor.java:1145)
> >>> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> >>> > ThreadPoolExecutor.java:615)
> >>> > at java.lang.Thread.run(Thread.java:745)
> >>> > Caused by: org.springframework.beans.factory.BeanCreationException:
> >>> Error
> >>> > creating bean with name
> >>> 'org.springframework.cache.config.internalCacheAdvisor':
> >>> > Cannot resolve reference to bean
> >>> >
> >>> > On Fri Feb 13 2015 at 8:32:48 PM Zhou, Qianhao <[email protected]
> >>> <mailto:
> >>> > [email protected]>> wrote:
> >>> > You should create your own table in hive.
> >>> >
> >>> > 2015年2月13日 下午10:47于 Santosh Akhilesh
> >>><[email protected]<mailto:
> >>> > [email protected]>>写道：
> >>> > Oh thanks. You mean I should create my own table schema and insert
> >>>data
> >>> and
> >>> > then need to import?
> >>> > Does it mean I should create tables in hbase ? Any specific location
> >>>?
> >>> I am
> >>> > quite new to hbase and hive so may be I have many silly questions.
> >>> > On Fri, 13 Feb 2015 at 8:05 pm, 周千昊 <[email protected]<mailto:z.
> >>> > [email protected]>> wrote:
> >>> >
> >>> > > Hi Santosh,
> >>> > > As you have setup a new hadoop environment, so there is no
> >>>data
> >>> in
> >>> > > hive. And we have not provided standalone data pack for this
> >>> situation.
> >>> > > That means you have to manually import the data into hive table.
> >>> > >
> >>> > > On Fri Feb 13 2015 at 10:26:57 PM Santosh Akhilesh <
> >>> > > [email protected]<mailto:[email protected]>>
> wrote:
> >>> > >
> >>> > > > I have seen this link but my question is how to get EDW data
> >>>source
> >>> as
> >>> > > > mentioned in tutorial
> >>> > > > On Fri, 13 Feb 2015 at 7:41 pm, 周千昊
> >>><[email protected]<mailto:z.
> >>> > [email protected]>> wrote:
> >>> > > >
> >>> > > > > Hi, Santosh
> >>> > > > > There is a tutorial about how to create a cube:
> >>> > > > > https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-
> >>> > > > Creation-Tutorial
> >>> > > > >
> >>> > > > > On Fri Feb 13 2015 at 10:05:55 PM Santosh Akhilesh <
> >>> > > > > [email protected]<mailto:[email protected]>>
> >>> wrote:
> >>> > > > >
> >>> > > > > > Hi Zhou,
> >>> > > > > > Yes I understand. I was wondering how do I use the create
> >>>cube
> >>> > > > tutorial.
> >>> > > > > If
> >>> > > > > > there are some sample tables exist for me to try out the
> >>>sample
> >>> > cube
> >>> > > > > > described in tutorial. I am quite new to these stuffs so if
> >>>you
> >>> can
> >>> > > > give
> >>> > > > > me
> >>> > > > > > pointers about how do I create sample hive tables and import
> >>>it
> >>> > would
> >>> > > > be
> >>> > > > > > great. Thanks for your quick responses. I know in China you
> >>>have
> >>> > > spring
> >>> > > > > > holidays but you guys still working :)
> >>> > > > > > Regards
> >>> > > > > > Santosh
> >>> > > > > > On Fri, 13 Feb 2015 at 7:13 pm, Zhou, Qianhao <
> >>> [email protected]
> >>> > <mailto:[email protected]>>
> >>> > > > wrote:
> >>> > > > > >
> >>> > > > > > > Hi Santosh
> >>> > > > > > > Kylin is not responsible for source of the data,
> >>>however
> >>> you
> >>> > > can
> >>> > > > > > > import table from your hive table, there is a tab in the
> >>>web
> >>> ui
> >>> > > > called
> >>> > > > > > > table, you can import the table there
> >>> > > > > > >
> >>> > > > > > > 2015年2月13日 下午9:33于 Santoshakhilesh <
> >>> [email protected]<
> >>> > mailto:[email protected]>>
> >>> > > 写道：
> >>> > > > > > > I saw the following link about creating the cube.
> >>> > > > > > >
> >>> > > > > > > https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-
> >>> > > Creation-Tutorial
> >>> > > > > > >
> >>> > > > > > > In this there is already source table EDW exist , But in my
> >>> > > > environment
> >>> > > > > > > there is no such table.
> >>> > > > > > > How can I create this table manually or I need to export
> >>>from
> >>> > > > > somewhere ?
> >>> > > > > > >
> >>> > > > > > > Also , how do I insert tables , data in table when I start
> >>> > creating
> >>> > > > my
> >>> > > > > > own
> >>> > > > > > > cubes and tables ?
> >>> > > > > > >
> >>> > > > > > >
> >>> > > > > > > Regards,
> >>> > > > > > > Santosh Akhilesh
> >>> > > > > > > Bangalore R&D
> >>> > > > > > > HUAWEI TECHNOLOGIES CO.,LTD.
> >>> > > > > > >
> >>> > > > > > >
> >>>www.huawei.com<http://www.huawei.com><http://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]<mailto:
> >>> > [email protected]>]
> >>> > > > > > > Sent: Friday, February 13, 2015 5:40 PM
> >>> > > > > > > To:
> >>>[email protected]<mailto:[email protected]
> >>> .
> >>> > apache.org>
> >>> > > > > > > Subject: RE: About building kylin
> >>> > > > > > >
> >>> > > > > > > Hi Zhou,
> >>> > > > > > > Thanks a million, it was hbase issue , now I am able to
> >>> login
> >>> > to
> >>> > > > > main
> >>> > > > > > > interface page.
> >>> > > > > > > In the documents I see a section of building cubes. are
> >>> there
> >>> > > any
> >>> > > > > > > sample cubles I can try with ?
> >>> > > > > > > Can you please tell me where can I get them and steps to
> >>> > import
> >>> > > > and
> >>> > > > > > > query them.
> >>> > > > > > >
> >>> > > > > > > Regards,
> >>> > > > > > > Santosh Akhilesh
> >>> > > > > > > Bangalore R&D
> >>> > > > > > > HUAWEI TECHNOLOGIES CO.,LTD.
> >>> > > > > > >
> >>> > > > > > >
> >>>www.huawei.com<http://www.huawei.com><http://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]<mailto:
> >>> > [email protected]>]
> >>> > > > > > > Sent: Friday, February 13, 2015 2:38 PM
> >>> > > > > > > To:
> >>>[email protected]<mailto:[email protected]
> >>> .
> >>> > apache.org>
> >>> > > > > > > Cc: Kulbhushan Rana
> >>> > > > > > > Subject: RE: About building kylin
> >>> > > > > > >
> >>> > > > > > > Hi Zhou,
> >>> > > > > > > The exceptions I see are below , So it seems Kylin
> >>> instance
> >>> > is
> >>> > > > not
> >>> > > > > > > deployed correctly;
> >>> > > > > > >
> >>> > > > > > > WARNING: Failed to scan
> >>> [file:/contrib/capacity-scheduler/*.jar]
> >>> > > > from
> >>> > > > > > > classloader hierarchy
> >>> > > > > > > java.io.FileNotFoundException:
> >>> /contrib/capacity-scheduler/*.jar
> >>> > > (No
> >>> > > > > > such
> >>> > > > > > > file or directory)
> >>> > > > > > > at java.util.zip.ZipFile.open(Native Method)
> >>> > > > > > > at java.util.zip.ZipFile.<init>(ZipFile.java:215)
> >>> > > > > > > at java.util.zip.ZipFile.<init>(ZipFile.java:145)
> >>> > > > > > > at java.util.jar.JarFile.<init>(JarFile.java:154)
> >>> > > > > > > at java.util.jar.JarFile.<init>(JarFile.java:91)
> >>> > > > > > >
> >>> > > > > > > Feb 13, 2015 10:27:32 PM org.apache.catalina.startup.
> >>> > ContextConfig
> >>> > > > > > > processResourceJARs
> >>> > > > > > > SEVERE: Failed to processes JAR found at URL
> >>> > > > > [jar:file:/contrib/capacity-
> >>> > > > > > scheduler/*.jar!/]
> >>> > > > > > > for static resources to be included in context with name
> >>> > > > > > > [jar:file:/contrib/capacity-scheduler/*.jar!/]
> >>> > > > > > >
> >>> > > > > > > resource loaded through InputStream
> >>> > > > > > > [localhost-startStop-1]:[2015-02-13
> >>>22:27:34,475][WARN][org.
> >>> > > > > > > apache.kylin.common.KylinConfig.getKylinProperties(
> >>> > > > > > KylinConfig.java:527)]
> >>> > > > > > > - KYLIN_CONF_HOME has not been set
> >>> > > > > > > 2015-02-13 22:27:34,919 INFO [localhost-startStop-1]
> >>> zookeeper.
> >>> > > > > > RecoverableZooKeeper:
> >>> > > > > > > Process identifier=hconnection-0x2b5a652e connecting to
> >>> > ZooKeeper
> >>> > > > > > > ensemble=localhost:2181
> >>> > > > > > >
> >>> > > > > > > 2015-02-13 22:27:34,958 INFO [localhost-startStop-1-
> >>> > > > > > SendThread(localhost:2181)]
> >>> > > > > > > zookeeper.ClientCnxn: Opening socket connection to server
> >>> > > > > > > localhost/0:0:0:0:0:0:0:1:2181. Will not attempt to
> >>> authenticate
> >>> > > > using
> >>> > > > > > > SASL (unknown error)
> >>> > > > > > > 2015-02-13 22:27:34,965 WARN [localhost-startStop-1-
> >>> > > > > > SendThread(localhost:2181)]
> >>> > > > > > > zookeeper.ClientCnxn: Session 0x0 for server null,
> >>>unexpected
> >>> > > error,
> >>> > > > > > > closing socket connection and attempting reconnect
> >>> > > > > > > java.net.ConnectException: Connection refused
> >>> > > > > > > at sun.nio.ch.SocketChannelImpl.checkConnect(Native
> >>>Method)
> >>> > > > > > > at sun.nio.ch.SocketChannelImpl.finishConnect(
> >>> > > > > > SocketChannelImpl.java:739)
> >>> > > > > > > at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(
> >>> > > > > > > ClientCnxnSocketNIO.java:361)
> >>> > > > > > > at org.apache.zookeeper.ClientCnxn$SendThread.run(
> >>> > > > > ClientCnxn.java:1081)
> >>> > > > > > > 2015-02-13 22:27:35,070 INFO [localhost-startStop-1-
> >>> > > > > > SendThread(localhost:2181)]
> >>> > > > > > > zookeeper.ClientCnxn: Opening socket connection to server
> >>> > > localhost/
> >>> > > > > > > 127.0.0.1:2181<http://127.0.0.1:2181>. Will not attempt to
> >>> > authenticate using SASL
> >>> > > (unknown
> >>> > > > > > > error)
> >>> > > > > > >
> >>> > > > > > > 2015-02-13 22:27:51,920 WARN [localhost-startStop-1]
> >>> zookeeper.
> >>> > > > > > RecoverableZooKeeper:
> >>> > > > > > > Possibly transient ZooKeeper, quorum=localhost:2181,
> >>> > > > > > exception=org.apache.
> >>> > > > > > > zookeeper.KeeperException$ConnectionLossException:
> >>> > > KeeperErrorCode =
> >>> > > > > > > ConnectionLoss for /hbase/hbaseid
> >>> > > > > > > 2015-02-13 22:27:51,921 ERROR [localhost-startStop-1]
> >>> zookeeper.
> >>> > > > > > RecoverableZooKeeper:
> >>> > > > > > > ZooKeeper exists failed after 4 attempts
> >>> > > > > > > 2015-02-13 22:27:51,921 WARN [localhost-startStop-1]
> >>> > > > zookeeper.ZKUtil:
> >>> > > > > > > hconnection-0x2b5a652e, quorum=localhost:2181,
> >>> baseZNode=/hbase
> >>> > > > Unable
> >>> > > > > to
> >>> > > > > > > set watcher on znode (/hbase/hbaseid)
> >>> > > > > > >
> >>>org.apache.zookeeper.KeeperException$ConnectionLossException:
> >>> > > > > > > KeeperErrorCode = ConnectionLoss for /hbase/hbaseid
> >>> > > > > > > at org.apache.zookeeper.KeeperException.create(
> >>> > > > > KeeperException.java:99)
> >>> > > > > > > at org.apache.zookeeper.KeeperException.create(
> >>> > > > > KeeperException.java:51)
> >>> > > > > > > at
> >>>org.apache.zookeeper.ZooKeeper.exists(ZooKeeper.java:1045)
> >>> > > > > > > at org.apache.hadoop.hbase.zookeeper.
> >>> > RecoverableZooKeeper.exists(
> >>> > > > > > > RecoverableZooKeeper.java:222)
> >>> > > > > > > at org.apache.hadoop.hbase.zookeeper.ZKUtil.checkExists(
> >>> > > > > > ZKUtil.java:479)
> >>> > > > > > > at org.apache.hadoop.hbase.zookeeper.ZKClusterId.
> >>> > > > readClusterIdZNode(
> >>> > > > > > > ZKClusterId.java:65)
> >>> > > > > > > at org.apache.hadoop.hbase.client.ZooKeeperRegistry.
> >>> > getClusterId(
> >>> > > > > > > ZooKeeperRegistry.java:83)
> >>> > > > > > > at org.apache.hadoop.hbase.client.HConnectionManager$
> >>> > > > > > > HConnectionImplementation.retrieveClusterId(
> >>> > > > > HConnectionManager.java:897)
> >>> > > > > > > at org.apache.hadoop.hbase.client.HConnectionManager$
> >>> > > > > > >
> >>>HConnectionImplementation.<init>(HConnectionManager.java:694)
> >>> > > > > > >
> >>> > > > > > >
> >>> > > > > > > Regards,
> >>> > > > > > > Santosh Akhilesh
> >>> > > > > > > Bangalore R&D
> >>> > > > > > > HUAWEI TECHNOLOGIES CO.,LTD.
> >>> > > > > > >
> >>> > > > > > >
> >>>www.huawei.com<http://www.huawei.com><http://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: Zhou, Qianhao [[email protected]<mailto:
> >>> [email protected]
> >>> > >]
> >>> > > > > > > Sent: Friday, February 13, 2015 2:07 PM
> >>> > > > > > > To:
> >>>[email protected]<mailto:[email protected]
> >>> .
> >>> > apache.org>
> >>> > > > > > > Subject: Re: About building kylin
> >>> > > > > > >
> >>> > > > > > > Hi, Santosh
> >>> > > > > > > Please check tomcat/logs/kylin.log to see if there is any
> >>> > exception
> >>> > > > > > >
> >>> > > > > > > Best Regard
> >>> > > > > > > Zhou QianHao
> >>> > > > > > >
> >>> > > > > > >
> >>> > > > > > >
> >>> > > > > > >
> >>> > > > > > >
> >>> > > > > > > On 2/13/15, 4:24 PM, "Santoshakhilesh" <
> >>> > > [email protected]<mailto:[email protected]>>
> >>> > > > > > > wrote:
> >>> > > > > > >
> >>> > > > > > > >Hi Zhou,
> >>> > > > > > > > I am able to access the http://127.0.0.17070/kylin
> >>> using
> >>> > > > > firefox
> >>> > > > > > > > All I get is a blank page , its not 404 , it means I
> >>> could
> >>> > > > > connect
> >>> > > > > > > >to web server successfully but there is some issue in
> >>> > rendering. I
> >>> > > > was
> >>> > > > > > > >noty asked for user name and password.
> >>> > > > > > > > When I run start kylin shell file , following
> >>>prompt
> >>> > really
> >>> > > > > means
> >>> > > > > > > >everuthing went ok , or I should check some log files to
> >>>know
> >>> > the
> >>> > > > real
> >>> > > > > > > >status ?
> >>> > > > > > > >A new Kylin instance is started by root, stop it using
> >>> > > > "stop-kylin.sh"
> >>> > > > > > > >Please visit http://<your_sandbox_ip>:7070/kylin to play
> >>> with
> >>> > the
> >>> > > > > > cubes!
> >>> > > > > > > >
> >>> > > > > > > >Regards,
> >>> > > > > > > >Santosh Akhilesh
> >>> > > > > > > >Bangalore R&D
> >>> > > > > > > >HUAWEI TECHNOLOGIES CO.,LTD.
> >>> > > > > > > >
> >>> > > > > > >
> >>>>www.huawei.com<http://www.huawei.com><http://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: Zhou, Qianhao [[email protected]<mailto:
> >>> [email protected]
> >>> > >]
> >>> > > > > > > >Sent: Friday, February 13, 2015 1:04 PM
> >>> > > > > > > >To: [email protected]<mailto:
> >>> [email protected].
> >>> > apache.org>
> >>> > > > > > > >Cc: Kulbhushan Rana
> >>> > > > > > > >Subject: Re: About building kylin
> >>> > > > > > > >
> >>> > > > > > > >Hi, Santosh
> >>> > > > > > > > You will see a kylin.war inside
> >>> > ${KYLIN_HOME}/tomcat/webapps.
> >>> > > > That
> >>> > > > > > is
> >>> > > > > > > >the server war package. The tomcat version is 7.0.59.
> >>> > > > > > > > If you want to bind 0.0.0.0:7070<http://0.0.0.0:7070
> >,
> >>> > please refer to the tomcat
> >>> > > > > > > document,
> >>> > > > > > > >there should be some configurations to let you do that.
> >>> > > > > > > >
> >>> > > > > > > >Best Regard
> >>> > > > > > > >Zhou QianHao
> >>> > > > > > > >
> >>> > > > > > > >
> >>> > > > > > > >
> >>> > > > > > > >
> >>> > > > > > > >
> >>> > > > > > > >On 2/13/15, 1:46 PM, "Santoshakhilesh" <
> >>> > > [email protected]<mailto:[email protected]>
> >>> > > > >
> >>> > > > > > > >wrote:
> >>> > > > > > > >
> >>> > > > > > > >>Hi Zhou,
> >>> > > > > > > >> Due to some practical constarints , I have to setup
> >>> > clusster
> >>> > > > > > > >>manually.
> >>> > > > > > > >> I have downloaded all the dependency like hadoop ,
> >>> hbase ,
> >>> > > > hive
> >>> > > > > ,
> >>> > > > > > > >>tomcat and I have run the check-env.sh after it passes ,
> >>>I
> >>> have
> >>> > > run
> >>> > > > > the
> >>> > > > > > > >>start-kylin.sh
> >>> > > > > > > >> Following is the log on console after running the
> >>> > > > > > ./start-kylin.sh.
> >>> > > > > > > >> Does this mean everything is ok or I should check
> >>>some
> >>> > > other
> >>> > > > > > logs ?
> >>> > > > > > > >>Currently I am unable to login to http://
> >>> > <your_sandbox_ip>:7070/
> >>> > > > > kylin
> >>> > > > > > > >>from outside the machine.
> >>> > > > > > > >> Is it possible to bind it to 0.0.0.0 :7070 so that I
> >>>can
> >>> > > > connect
> >>> > > > > > from
> >>> > > > > > > >>outside the lab network ? Where can I configure this ?
> >>> > > > > > > >>
> >>> > > > > > > >> ./start-kylin.sh
> >>> > > > > > > >>Checking KYLIN_HOME...
> >>> > > > > > > >>KYLIN_HOME is set to /opt/kylinb
> >>> > > > > > > >>Checking hbase...
> >>> > > > > > > >>hbase check passed
> >>> > > > > > > >>Checking hive...
> >>> > > > > > > >>hive check passed
> >>> > > > > > > >>Checking hadoop...
> >>> > > > > > > >>hadoop check passed
> >>> > > > > > > >>Logging initialized using configuration in
> >>> > > > > > > >>jar:file:/opt/hive/apache-hive-0.14.0-bin/lib/hive-
> >>> > > > > > > common-0.14.0.jar!/hiv
> >>> > > > > > > >>e
> >>> > > > > > > >>-log4j.properties
> >>> > > > > > > >>SLF4J: Class path contains multiple SLF4J bindings.
> >>> > > > > > > >>SLF4J: Found binding in
> >>> > > > > > > >>[jar:file:/opt/hadoop/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:/opt/hive/apache-hive-0.14.0-bin/lib/hive-jdbc-
> >>> > > > > > > 0.14.0-standalon
> >>> > > > > > > >>e
> >>> > > > > > > >>.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]
> >>> > > > > > > >>hive dependency:
> >>> > > > > > > >>/usr/hdp/current/hive-client/conf/:/hive/lib/*:/
> >>> > > > > > > hive-hcatalog/share/hcata
> >>> > > > > > > >>l
> >>> > > > > > > >>og/*
> >>> > > > > > > >>A new Kylin instance is started by root, stop it using
> >>> > > > > "stop-kylin.sh"
> >>> > > > > > > >>Please visit http://<your_sandbox_ip>:7070/kylin to play
> >>> with
> >>> > > the
> >>> > > > > > cubes!
> >>> > > > > > > >>(Useranme: ADMIN, Password: KYLIN)
> >>> > > > > > > >>You can check the log at ./../tomcat/logs/kylin.log
> >>> > > > > > > >>
> >>> > > > > > > >>Regards,
> >>> > > > > > > >>Santosh Akhilesh
> >>> > > > > > > >>Bangalore R&D
> >>> > > > > > > >>HUAWEI TECHNOLOGIES CO.,LTD.
> >>> > > > > > > >>
> >>> > > > > > >
> >>>>>www.huawei.com<http://www.huawei.com><http://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: Zhou, Qianhao [[email protected]<mailto:qian
> >>> > [email protected]>]
> >>> > > > > > > >>Sent: Thursday, February 12, 2015 2:59 PM
> >>> > > > > > > >>To: [email protected]<mailto:
> >>> [email protected].
> >>> > apache.org>
> >>> > > > > > > >>Subject: Re: About building kylin
> >>> > > > > > > >>
> >>> > > > > > > >>Hi Santosh
> >>> > > > > > > >> Surely you can run kylin on single node.
> >>> > > > > > > >> Currently kylin is depend on
> >>> > > > > > > >> 1. Hive (where source data come from)
> >>> > > > > > > >> 2. HBase (where metadata and pre-computed data stored)
> >>> > > > > > > >> However once you have the hadoop environment ready, it
> >>> does
> >>> > > not
> >>> > > > > > matter
> >>> > > > > > > >>how many vm running in the cluster.
> >>> > > > > > > >> As for your circumstances, a sandbox is strongly
> >>> recommended
> >>> > > > which
> >>> > > > > > > >>will
> >>> > > > > > > >>save you a lot of time of setting up the environment.
> >>> > Hortonworks
> >>> > > > or
> >>> > > > > > > >>Cloudera will be good choice.
> >>> > > > > > > >>
> >>> > > > > > > >>Best Regard
> >>> > > > > > > >>Zhou QianHao
> >>> > > > > > >
> >>> > > > > >
> >>> > > > >
> >>> > > >
> >>> > >
> >>>
> >>
> >>
> >>
> >> --
> >> Regards,
> >> Santosh Akhilesh
> >> +91-0-9845482201
> >>
> >
> >
> >
> >--
> >Regards,
> >Santosh Akhilesh
> >+91-0-9845482201
>
>
--
Regards,
Santosh Akhilesh
+91-0-9845482201
