About ssahi

ssahi · ‎08-24-2017

hi @L Hurley Are you specifying the port? http://127.0.0.1:8080/ When you are logged in as root@sandbox, try also running: ambari-server status and ensure its running.

ssahi · ‎08-24-2017

Hi @Ramya Jayathirtha Try the following: create table movies( movieid int, title String, genre string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' This should resolve your issue as the OpenCSVSerde's default properties should work for your use case.

ssahi · ‎08-24-2017

You'll need to check the entire error message, typically the root cause is somewhere near the bottom

ssahi · ‎08-24-2017

Hi @L Hurley From the snippet you pasted, you are already logged in! You are logged into the sandbox as root, so ssh'ing in a second time would surley result in an error. root@sandbox

ssahi · ‎08-23-2017

hi @L Hurley what you want to do is open the known_hosts file in a text editor and delete any lines that correspond with the IP address of the sandbox, which in your case is 127.0.0.1 and then try it again

ssahi · ‎08-23-2017

hi @Ashnee Sharma You'll likely need to go through the whole error message, the underlying root cause will be in the error/exception message. Typically, you can see that when the data node storage is full, or when network communication was severed.

ssahi · ‎08-22-2017

hi @nfleming No I am not claiming that. You can change the property within the same session as you see fit.

ssahi · ‎08-21-2017

Looks like the key has changed. On your local system, go into .ssh/known_hosts and just delete any lines related to the sandbox. Then try the ssh again on -p 2222 and you'll be prompted to re-accept the key and should be good to go.

ssahi · ‎08-21-2017

Hi @L Hurley Can you try the ssh command again but use port 2222 ? 8080 is usually the default web port for the Ambari UI.

ssahi · ‎08-21-2017

Hi @scottgr Writing scripts is usually the most popular way. The scripts can be automated through a number of ways including oozie/workflow manager UI in Ambari. While it is a common task, each use case is different. We can't make a general assumption about any cluster since to some people, older data may be more important than newer data depending on the data set. It gets even further complicated in multi-tenant datalakes as you can imagine.

Online	Offline
Last Visited	‎08-29-2019 11:23 AM

Member Since	‎08-23-2016 04:51 AM
Last Visited	‎08-29-2019 11:23 AM
Posts	261
Kudos received	194

Cloudera Community

Re: Hiveserver2 Interactive (Hive2) High Availabil...

Re: Does phoenix query server support connectivity...

Re: How to check Kafka version

Re: Run HIVE queries in command shell (cmd), not i...

Re: HDP and Ambari releases for HDPCA Exam

Re: Connection refused -- 2.6

Re: Hive- escaping field delimiter in column value

Re: getting error for hadoop command.

Re: Connection refused -- 2.6

Re: Connection refused -- 2.6

Re: getting error for hadoop command.

Re: Setting within script hive.tez.container.size

Re: Connection refused -- 2.6

Re: Connection refused -- 2.6

Re: Deleting old data from HDFS once storage appro...