Ruilong, thanks for the feedback. i've updated the wiki to include 1. 2. and 3. If you get an error "WARNING: instance already exists in ..." make sure you clean up pxf-service directory under $PXF_HOME/bin/pxf and rerun init. Let me know if that fixes your issue.
Oleksander, can you provide your feedback as well if you noticed any issues ? Regards On Fri, Feb 3, 2017 at 10:43 PM, Ruilong Huo <[email protected]> wrote: > Hi Shivram, > > Thanks Shivram for sharing the great wiki page! I tried it on osx and here > are some issue so far: > > 1. Add hive version which is compatible with pxf. Seems pxf only support > hive 1.x. > > 2. Add "hive --service metastore &" to start hive metastore before start > hive > > 3. Add "export HADOOP_USER_CLASSPATH_FIRST=true" since it might fail to > start hive with error "Terminal initialization failed; falling back to > unsupported". > > After pxf is configured and hive is started, it failed to initialize pxf > with error that tomcat is not running. Is there any step to configure > tomcat? > > *rhuo-mbp:pxf rhuo$ > /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/pxf/bin/pxf init* > *WARNING: instance already exists in > /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/pxf, nothing to do...* > > *rhuo-mbp:pxf rhuo$ > /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/pxf/bin/pxf > statusChecking if tomcat is up and running...* > *ERROR: PXF is down - tomcat is not running* > > > *rhuo-mbp:pxf rhuo$ ps -ef | grep tomcat* > * 501 3654 1 0 2:16PM ttys001 0:05.48 > /Library/Java/JavaVirtualMachines/jdk1.7.0_72.jdk/Contents/Home/bin/java > -Djava.util.logging.config.file=/Users/rhuo/Workspace/ > hawq/hawq-2.0/hawq-db-devel/pxf/apache-tomcat/conf/logging.properties > -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager > -Djava.endorsed.dirs=/Users/rhuo/Workspace/hawq/hawq-2.0/ > hawq-db-devel/pxf/apache-tomcat/endorsed > -classpath > /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/pxf/ > apache-tomcat/bin/bootstrap.jar:/Users/rhuo/Workspace/ > hawq/hawq-2.0/hawq-db-devel/pxf/apache-tomcat/bin/tomcat-juli.jar > -Dcatalina.base=/Users/rhuo/Workspace/hawq/hawq-2.0/hawq- > db-devel/pxf/apache-tomcat > -Dcatalina.home=/Users/rhuo/Workspace/hawq/hawq-2.0/hawq- > db-devel/pxf/apache-tomcat > -Djava.io.tmpdir=/Users/rhuo/Workspace/hawq/hawq-2.0/hawq- > db-devel/pxf/apache-tomcat/temp > org.apache.catalina.startup.Bootstrap start* > > > Best regards, > Ruilong Huo > > On Tue, Jan 31, 2017 at 9:27 AM, Shivram Mani <[email protected]> > wrote: > > > I've created this wiki > > <https://cwiki.apache.org/confluence/display/HAWQ/PXF+Build+and+Install> > > that > > documents the instructions to Build/Deploy/Test PXF using HAWQ against > > Hadoop and Hive. Please give this a try (on mac/unix) on your local dev > > environments and provide your feedback. > > > > > > Regards > > -- > > shivram mani > > > -- shivram mani
