You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Qiuzhuang Lian <qi...@gmail.com> on 2016/07/13 16:33:00 UTC
Fwd: can't start up hive 2.1 hiveserver2/metastore services
We download hive 2.1 and run into errors when starting to
metastore/hiveserver2 services, here is the errors,
Any clues?
Regards,
Qiuzhuang
[image: Inline image 1]
Re: can't start up hive 2.1 hiveserver2/metastore services
Posted by Qiuzhuang Lian <qi...@gmail.com>.
we have multiple hive versions installed on the same machine and we use
export HIVE_HOME via CLI which I think it is why we run into that issue.
As suggested, we use the complete execution CLI path and it looks good.
Thanks and closing this issue.
regards,
Q
On Thu, Jul 14, 2016 at 12:27 PM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> wrote:
> Hi qiuzhuang
>
> hive is a bash file.
>
> try running it with
>
> sh -x $HIVE_HOME/bin/hive --service metastore
>
>
> To see where it is failing.
>
> In general I source the environment file before running the query. I am on
> Hive 2 and it works. Have not tried Hive 2.1
>
> #!/bin/ksh
> ENVFILE=/home/hduser/dba/bin/environment.ksh
> if [[ -f $ENVFILE ]]
> then
> . $ENVFILE
> else
> echo "Abort: $0 failed. No environment file ( $ENVFILE ) found"
> exit 1
> fi
> FILE_NAME=`basename $0 .ksh`
> LOG_FILE=${LOGDIR}/${FILE_NAME}.log
> [ -f ${LOG_FILE} ] && rm -f ${LOG_FILE}
> echo `date` " ""======= Starting hiveserver metastore =======" >>
> ${LOG_FILE}
> $HIVE_HOME/bin/hive --service metastore &
> netstat -alnp|egrep 'Local|9083'
> echo `date` " ""======= Started hiveserver2 metastore =======" >>
> ${LOG_FILE}
> exit
>
> HTH
>
>
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk. Any and all responsibility for any
> loss, damage or destruction of data or any other property which may arise
> from relying on this email's technical content is explicitly disclaimed.
> The author will in no case be liable for any monetary damages arising from
> such loss, damage or destruction.
>
>
>
> On 14 July 2016 at 03:01, Qiuzhuang Lian <qi...@gmail.com> wrote:
>
>> Hi Mich,
>>
>>
>> I have to use this command:
>>
>> bin/hive --service metastore
>>
>> then it works.
>>
>> While setting HIVE_HOME and add hive bin path, then issue command as
>> follows,
>>
>> hive --service metastore
>>
>> it would breaks.
>>
>> I think shell under bin should be improved to address this?
>>
>> Regards,
>> qiuzhuang
>>
>>
>>
>> On Thu, Jul 14, 2016 at 12:39 AM, Mich Talebzadeh <
>> mich.talebzadeh@gmail.com> wrote:
>>
>>> Can hardly read the image :)
>>>
>>> Did you start the metastore before?
>>>
>>> $HIVE_HOME/bin/hive --service metastore &
>>>
>>> Assuming it is running on default port 9083 do you see the process
>>>
>>> netstat -alnp|egrep 'Local|9083'
>>>
>>>
>>> and then the same for Hive thrift server
>>>
>>> $HIVE_HOME/bin/hiveserver2 &
>>>
>>> By default that runs on port 10000
>>>
>>>
>>> HTH
>>>
>>> Dr Mich Talebzadeh
>>>
>>>
>>>
>>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>
>>>
>>>
>>> http://talebzadehmich.wordpress.com
>>>
>>>
>>> *Disclaimer:* Use it at your own risk. Any and all responsibility for
>>> any loss, damage or destruction of data or any other property which may
>>> arise from relying on this email's technical content is explicitly
>>> disclaimed. The author will in no case be liable for any monetary damages
>>> arising from such loss, damage or destruction.
>>>
>>>
>>>
>>> On 13 July 2016 at 17:33, Qiuzhuang Lian <qi...@gmail.com>
>>> wrote:
>>>
>>>> We download hive 2.1 and run into errors when starting to
>>>> metastore/hiveserver2 services, here is the errors,
>>>>
>>>> Any clues?
>>>>
>>>> Regards,
>>>> Qiuzhuang
>>>>
>>>> [image: Inline image 1]
>>>>
>>>>
>>>>
>>>
>>
>
Re: can't start up hive 2.1 hiveserver2/metastore services
Posted by Mich Talebzadeh <mi...@gmail.com>.
Hi qiuzhuang
hive is a bash file.
try running it with
sh -x $HIVE_HOME/bin/hive --service metastore
To see where it is failing.
In general I source the environment file before running the query. I am on
Hive 2 and it works. Have not tried Hive 2.1
#!/bin/ksh
ENVFILE=/home/hduser/dba/bin/environment.ksh
if [[ -f $ENVFILE ]]
then
. $ENVFILE
else
echo "Abort: $0 failed. No environment file ( $ENVFILE ) found"
exit 1
fi
FILE_NAME=`basename $0 .ksh`
LOG_FILE=${LOGDIR}/${FILE_NAME}.log
[ -f ${LOG_FILE} ] && rm -f ${LOG_FILE}
echo `date` " ""======= Starting hiveserver metastore =======" >>
${LOG_FILE}
$HIVE_HOME/bin/hive --service metastore &
netstat -alnp|egrep 'Local|9083'
echo `date` " ""======= Started hiveserver2 metastore =======" >>
${LOG_FILE}
exit
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.
On 14 July 2016 at 03:01, Qiuzhuang Lian <qi...@gmail.com> wrote:
> Hi Mich,
>
>
> I have to use this command:
>
> bin/hive --service metastore
>
> then it works.
>
> While setting HIVE_HOME and add hive bin path, then issue command as
> follows,
>
> hive --service metastore
>
> it would breaks.
>
> I think shell under bin should be improved to address this?
>
> Regards,
> qiuzhuang
>
>
>
> On Thu, Jul 14, 2016 at 12:39 AM, Mich Talebzadeh <
> mich.talebzadeh@gmail.com> wrote:
>
>> Can hardly read the image :)
>>
>> Did you start the metastore before?
>>
>> $HIVE_HOME/bin/hive --service metastore &
>>
>> Assuming it is running on default port 9083 do you see the process
>>
>> netstat -alnp|egrep 'Local|9083'
>>
>>
>> and then the same for Hive thrift server
>>
>> $HIVE_HOME/bin/hiveserver2 &
>>
>> By default that runs on port 10000
>>
>>
>> HTH
>>
>> Dr Mich Talebzadeh
>>
>>
>>
>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>> *Disclaimer:* Use it at your own risk. Any and all responsibility for
>> any loss, damage or destruction of data or any other property which may
>> arise from relying on this email's technical content is explicitly
>> disclaimed. The author will in no case be liable for any monetary damages
>> arising from such loss, damage or destruction.
>>
>>
>>
>> On 13 July 2016 at 17:33, Qiuzhuang Lian <qi...@gmail.com>
>> wrote:
>>
>>> We download hive 2.1 and run into errors when starting to
>>> metastore/hiveserver2 services, here is the errors,
>>>
>>> Any clues?
>>>
>>> Regards,
>>> Qiuzhuang
>>>
>>> [image: Inline image 1]
>>>
>>>
>>>
>>
>
Re: can't start up hive 2.1 hiveserver2/metastore services
Posted by Qiuzhuang Lian <qi...@gmail.com>.
Hi Mich,
I have to use this command:
bin/hive --service metastore
then it works.
While setting HIVE_HOME and add hive bin path, then issue command as
follows,
hive --service metastore
it would breaks.
I think shell under bin should be improved to address this?
Regards,
qiuzhuang
On Thu, Jul 14, 2016 at 12:39 AM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> wrote:
> Can hardly read the image :)
>
> Did you start the metastore before?
>
> $HIVE_HOME/bin/hive --service metastore &
>
> Assuming it is running on default port 9083 do you see the process
>
> netstat -alnp|egrep 'Local|9083'
>
>
> and then the same for Hive thrift server
>
> $HIVE_HOME/bin/hiveserver2 &
>
> By default that runs on port 10000
>
>
> HTH
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk. Any and all responsibility for any
> loss, damage or destruction of data or any other property which may arise
> from relying on this email's technical content is explicitly disclaimed.
> The author will in no case be liable for any monetary damages arising from
> such loss, damage or destruction.
>
>
>
> On 13 July 2016 at 17:33, Qiuzhuang Lian <qi...@gmail.com> wrote:
>
>> We download hive 2.1 and run into errors when starting to
>> metastore/hiveserver2 services, here is the errors,
>>
>> Any clues?
>>
>> Regards,
>> Qiuzhuang
>>
>> [image: Inline image 1]
>>
>>
>>
>
Re: can't start up hive 2.1 hiveserver2/metastore services
Posted by Qiuzhuang Lian <qi...@gmail.com>.
Thanks, I can start hivesever2&metastore with hive 1.2.1 before. This error
happened to 2.X. The error indicates that it throws ClassNotFound exception
with service-rpc-*.jar.
Thanks.
Qiuzhuang
On Thu, Jul 14, 2016 at 12:39 AM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> wrote:
> Can hardly read the image :)
>
> Did you start the metastore before?
>
> $HIVE_HOME/bin/hive --service metastore &
>
> Assuming it is running on default port 9083 do you see the process
>
> netstat -alnp|egrep 'Local|9083'
>
>
> and then the same for Hive thrift server
>
> $HIVE_HOME/bin/hiveserver2 &
>
> By default that runs on port 10000
>
>
> HTH
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk. Any and all responsibility for any
> loss, damage or destruction of data or any other property which may arise
> from relying on this email's technical content is explicitly disclaimed.
> The author will in no case be liable for any monetary damages arising from
> such loss, damage or destruction.
>
>
>
> On 13 July 2016 at 17:33, Qiuzhuang Lian <qi...@gmail.com> wrote:
>
>> We download hive 2.1 and run into errors when starting to
>> metastore/hiveserver2 services, here is the errors,
>>
>> Any clues?
>>
>> Regards,
>> Qiuzhuang
>>
>> [image: Inline image 1]
>>
>>
>>
>
Re: can't start up hive 2.1 hiveserver2/metastore services
Posted by Mich Talebzadeh <mi...@gmail.com>.
Can hardly read the image :)
Did you start the metastore before?
$HIVE_HOME/bin/hive --service metastore &
Assuming it is running on default port 9083 do you see the process
netstat -alnp|egrep 'Local|9083'
and then the same for Hive thrift server
$HIVE_HOME/bin/hiveserver2 &
By default that runs on port 10000
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.
On 13 July 2016 at 17:33, Qiuzhuang Lian <qi...@gmail.com> wrote:
> We download hive 2.1 and run into errors when starting to
> metastore/hiveserver2 services, here is the errors,
>
> Any clues?
>
> Regards,
> Qiuzhuang
>
> [image: Inline image 1]
>
>
>