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 <shivram.m...@gmail.com> 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 >
