Re: Create external table with s3 location error

2018-11-07 Thread Suresh Kumar Sethuramaswamy
SocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) > > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) > > at java.net.Socket.connect(Socket.java:58

Re: Create external table with s3 location error

2018-11-07 Thread Garry Chen
Yes, it works. Thank you very much, Garry From: Suresh Kumar Sethuramaswamy Reply-To: "user@hive.apache.org" Date: Wednesday, November 7, 2018 at 3:10 PM To: "user@hive.apache.org" Subject: Re: Create external table with s3 location error Thanks for the logs. Couple of th

Re: Create external table with s3 location error

2018-11-07 Thread Garry Chen
.(SessionHiveMetaStoreClient.java:74) From: Suresh Kumar Sethuramaswamy Reply-To: "user@hive.apache.org" Date: Wednesday, November 7, 2018 at 2:50 PM To: "user@hive.apache.org" Subject: Re: Create external table with s3 location error Are you using EMR or Apache hadoop open source? Can you share

Re: Create external table with s3 location error

2018-11-07 Thread Suresh Kumar Sethuramaswamy
Are you using EMR or Apache hadoop open source? Can you share your hive megastore logs? On Wed, Nov 7, 2018, 2:19 PM Garry Chen hi All, > > I am try to create a external table using s3 as location > but failed. I add my access key and security key in hive-site.xml and > reboot t

Create external table with s3 location error

2018-11-07 Thread Garry Chen
hi All, I am try to create a external table using s3 as location but failed. I add my access key and security key in hive-site.xml and reboot the server. Any suggestion? hive> create external table kv (key int, values string) location 's3://cu-iclick/test'; FAILED: Execution