Just had a thought: Could it be that my Mac Java version is too new? Mac: $ java -version java version "1.8.0_60" Java(TM) SE Runtime Environment (build 1.8.0_60-b27) Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)
EMR node: $ java -version java version "1.7.0_71" Java(TM) SE Runtime Environment (build 1.7.0_71-b14) Java HotSpot(TM) 64-Bit Server VM (build 24.71-b01, mixed mode) I may try a switching to 1.7 later and report back. On Sun, Nov 1, 2015 at 9:24 AM, Steve Terrell <[email protected]> wrote: > Thanks, but I'm trying to run remotely. I'm sure my /etc/hosts is fine as > I can ssh and "telnet <host> <ip>" OK. > > On Sun, Nov 1, 2015 at 9:21 AM, Steve Terrell <[email protected]> > wrote: > >> Thank you, but I'm sure this is not the case as I can easily run Squirrel >> client on my mac and query an older version of Phoenix (on another cluster) >> via port 2181. >> >> On Sat, Oct 31, 2015 at 2:21 PM, Naor David <[email protected]> wrote: >> >>> run netstat -a 1 | grep "SYN_SENT" and check if port 2181 is blocked in >>> your network.. >>> >>> On Sat, Oct 31, 2015 at 8:00 PM, Steve Terrell <[email protected]> >>> wrote: >>> >>>> OK, did some more troubleshooting. Still can't run sqlline.py from my >>>> macbook laptop. Still hangs. >>>> >>>> My HBase cluster is an Amazon EMR, and I can run sqlline.py from any of >>>> nodes in the cluster, be they master, core, or task nodes. >>>> >>>> So maybe it's not so much a remote host issue but a problem with my Mac >>>> or some kind of Amazon EMR security issue. But, I've tried opening up all >>>> ports just in case something other than 2181 is required, and no luck. >>>> >>>> Has anyone run this version of Phoenix on EMR and been able to use >>>> sqlline.py or SQuirreL client remotely from outside of AWS's private >>>> network? >>>> >>>> (My ultimate goal was to get SQuirreL working, but though sqlline.py >>>> would be an easier problem to tackle. SQuirreL is getting timeouts which I >>>> suspect are due to the same hanging that I see with sqlline.py.) >>>> >>>> Thanks, >>>> Steve >>>> >>>> On Wed, Oct 28, 2015 at 5:04 PM, Steve Terrell <[email protected]> >>>> wrote: >>>> >>>>> Yes, I can: >>>>> >>>>> $ telnet *<my master ip>* 2181 >>>>> Trying 54.174.32.95... >>>>> Connected to *<my master host name>*. >>>>> Escape character is '^]'. >>>>> >>>>> Thanks, >>>>> Steve >>>>> >>>>> On Wed, Oct 28, 2015 at 4:48 PM, Alok Singh <[email protected]> >>>>> wrote: >>>>> >>>>>> It looks like a zookeeper node is also on the master. Can you connect >>>>>> to <master ip> on port 2181 from the machine that you are running >>>>>> sqlline.py on? >>>>>> >>>>>> Alok >>>>>> >>>>>> Alok >>>>>> >>>>>> [email protected] >>>>>> >>>>>> On Wed, Oct 28, 2015 at 2:23 PM, Steve Terrell <[email protected] >>>>>> > wrote: >>>>>> >>>>>>> I can get "sqlline.py localhost" to work fine from the master node. >>>>>>> >>>>>>> However, when I try to run it remotely, all I get is this: >>>>>>> >>>>>>> java -cp "*<my path>*/phoenix-4.6.0-HBase-0.98-client.jar" >>>>>>> -Dlog4j.configuration=file:*<my path>*/log4j.properties >>>>>>> sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u >>>>>>> jdbc:phoenix:*<my >>>>>>> master ip*>:2181:/hbase -n none -p none --color=true >>>>>>> --fastConnect=false --verbose=true >>>>>>> --isolation=TRANSACTION_READ_COMMITTED >>>>>>> >>>>>>> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >>>>>>> issuing: !connect jdbc:phoenix:*<my master ip*>:2181:/hbase none >>>>>>> none org.apache.phoenix.jdbc.PhoenixDriver >>>>>>> Connecting to jdbc:phoenix:*<my master ip*>:2181:/hbase >>>>>>> 15/10/28 15:29:44 WARN util.NativeCodeLoader: Unable to load >>>>>>> native-hadoop library for your platform... using builtin-java classes >>>>>>> where >>>>>>> applicable >>>>>>> >>>>>>> And then it just hangs. Has anyone else come across this? >>>>>>> >>>>>>> Thanks, >>>>>>> Steve >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
