You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by Sean Broeder <se...@esgyn.com> on 2016/01/25 18:11:57 UTC
Test hanging
Hi,
I am trying to validate some changes before committing them and I am
consistently seeing a hive test hang at the same statement. Even after
backing my changes out the test hangs. Is this a known issue or likely
still something wrong in my environement?
>>-- insert some data and add one more partition
>>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
insert overwrite table customer_ddl
select
c_customer_sk,
c_customer_id,
c_current_cdemo_sk,
c_current_hdemo_sk,
c_current_addr_sk,
c_first_shipto_date_sk,
c_first_sales_date_sk,
c_salutation,
c_first_name,
c_last_name,
c_preferred_cust_flag,
c_birth_day,
c_birth_month,
c_birth_year,
c_birth_country,
c_login,
c_email_address,
c_last_review_date
from customer
where c_customer_sk < 20000
--Hangs here
I executed this test through the ./tools/runallsb from the sql/regress
directory.
Thanks,
Sean
Re: Test hanging
Posted by Hans Zeller <ha...@esgyn.com>.
Created TRAFODION-1780
<https://issues.apache.org/jira/browse/TRAFODION-1780>.
Hans
On Tue, Jan 26, 2016 at 9:17 AM, Qifan Chen <qi...@esgyn.com> wrote:
> +1.
>
> On Tue, Jan 26, 2016 at 11:12 AM, Sean Broeder <se...@esgyn.com>
> wrote:
>
> > Perhaps this property setting should be made default in
> > install_local_hadoop?
> >
> > Thanks,
> > Sean
> >
> > -----Original Message-----
> > From: Qifan Chen [mailto:qifan.chen@esgyn.com]
> > Sent: Tuesday, January 26, 2016 9:10 AM
> > To: dev <de...@trafodion.incubator.apache.org>
> > Subject: Re: Test hanging
> >
> > Hi Sean,
> >
> > Thank you for the tip. It helps solving another hung problem in my
> > hive/orc
> > loading test.
> >
> > Thanks --Qifan
> >
> >
> >
> > On Mon, Jan 25, 2016 at 10:05 PM, Sean Broeder <se...@esgyn.com>
> > wrote:
> >
> > > Thanks to the suggestion below my problem of tests hanging is solved.
> > >
> > > Much appreciated!
> > > Sean
> > >
> > > -----Original Message-----
> > > From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> > > Sent: Monday, January 25, 2016 11:15 AM
> > > To: 'dev@trafodion.incubator.apache.org'
> > > <de...@trafodion.incubator.apache.org>
> > > Subject: RE: Test hanging
> > >
> > > Thanks Hans,
> > > I'm trying a suggestion to add a property to the mapred-site.xml file
> - …
> > > <property>
> > > <name>mapreduce.framework.name</name>
> > > <value>local</value> == from yarn to local
> > > </property>
> > > …
> > >
> > > I've restarted all and am waiting to see if the condition hits again.
> > >
> > > Regards,
> > > Sean
> > >
> > > -----Original Message-----
> > > From: Hans Zeller [mailto:hans.zeller@esgyn.com]
> > > Sent: Monday, January 25, 2016 11:09 AM
> > > To: dev <de...@trafodion.incubator.apache.org>
> > > Subject: Re: Test hanging
> > >
> > > Hi Sean, this is probably related to MapReduce, this particular
> > > statement will start MapReduce jobs. You can check whether Yarn and
> > > the other required Hadoop components are up, or just try restarting
> > > your Hadoop environment.
> > > You can also look at the Yarn web page to see whether you have any
> > > stuck requests. If you use install_local_hadoop, open page
> > > $MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
> > >
> > > Hans
> > >
> > > On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com>
> > > wrote:
> > >
> > > > It is working fine for me, last time I ran was Friday night.
> > > > Eric
> > > >
> > > > -----Original Message-----
> > > > From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> > > > Sent: Monday, January 25, 2016 11:12 AM
> > > > To: dev@trafodion.incubator.apache.org
> > > > Subject: Test hanging
> > > >
> > > > Hi,
> > > >
> > > > I am trying to validate some changes before committing them and I am
> > > > consistently seeing a hive test hang at the same statement. Even
> > > > after backing my changes out the test hangs. Is this a known issue
> > > > or likely still something wrong in my environement?
> > > >
> > > >
> > > >
> > > > >>-- insert some data and add one more partition
> > > >
> > > > >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
> > > >
> > > >
> > > >
> > > > insert overwrite table customer_ddl
> > > >
> > > > select
> > > >
> > > > c_customer_sk,
> > > >
> > > > c_customer_id,
> > > >
> > > > c_current_cdemo_sk,
> > > >
> > > > c_current_hdemo_sk,
> > > >
> > > > c_current_addr_sk,
> > > >
> > > > c_first_shipto_date_sk,
> > > >
> > > > c_first_sales_date_sk,
> > > >
> > > > c_salutation,
> > > >
> > > > c_first_name,
> > > >
> > > > c_last_name,
> > > >
> > > > c_preferred_cust_flag,
> > > >
> > > > c_birth_day,
> > > >
> > > > c_birth_month,
> > > >
> > > > c_birth_year,
> > > >
> > > > c_birth_country,
> > > >
> > > > c_login,
> > > >
> > > > c_email_address,
> > > >
> > > > c_last_review_date
> > > >
> > > > from customer
> > > >
> > > > where c_customer_sk < 20000
> > > >
> > > >
> > > >
> > > > --Hangs here
> > > >
> > > >
> > > >
> > > > I executed this test through the ./tools/runallsb from the
> > > > sql/regress directory.
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Sean
> > > >
> > >
> >
> >
> >
> > --
> > Regards, --Qifan
> >
>
>
>
> --
> Regards, --Qifan
>
Re: Test hanging
Posted by Qifan Chen <qi...@esgyn.com>.
+1.
On Tue, Jan 26, 2016 at 11:12 AM, Sean Broeder <se...@esgyn.com>
wrote:
> Perhaps this property setting should be made default in
> install_local_hadoop?
>
> Thanks,
> Sean
>
> -----Original Message-----
> From: Qifan Chen [mailto:qifan.chen@esgyn.com]
> Sent: Tuesday, January 26, 2016 9:10 AM
> To: dev <de...@trafodion.incubator.apache.org>
> Subject: Re: Test hanging
>
> Hi Sean,
>
> Thank you for the tip. It helps solving another hung problem in my
> hive/orc
> loading test.
>
> Thanks --Qifan
>
>
>
> On Mon, Jan 25, 2016 at 10:05 PM, Sean Broeder <se...@esgyn.com>
> wrote:
>
> > Thanks to the suggestion below my problem of tests hanging is solved.
> >
> > Much appreciated!
> > Sean
> >
> > -----Original Message-----
> > From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> > Sent: Monday, January 25, 2016 11:15 AM
> > To: 'dev@trafodion.incubator.apache.org'
> > <de...@trafodion.incubator.apache.org>
> > Subject: RE: Test hanging
> >
> > Thanks Hans,
> > I'm trying a suggestion to add a property to the mapred-site.xml file - …
> > <property>
> > <name>mapreduce.framework.name</name>
> > <value>local</value> == from yarn to local
> > </property>
> > …
> >
> > I've restarted all and am waiting to see if the condition hits again.
> >
> > Regards,
> > Sean
> >
> > -----Original Message-----
> > From: Hans Zeller [mailto:hans.zeller@esgyn.com]
> > Sent: Monday, January 25, 2016 11:09 AM
> > To: dev <de...@trafodion.incubator.apache.org>
> > Subject: Re: Test hanging
> >
> > Hi Sean, this is probably related to MapReduce, this particular
> > statement will start MapReduce jobs. You can check whether Yarn and
> > the other required Hadoop components are up, or just try restarting
> > your Hadoop environment.
> > You can also look at the Yarn web page to see whether you have any
> > stuck requests. If you use install_local_hadoop, open page
> > $MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
> >
> > Hans
> >
> > On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com>
> > wrote:
> >
> > > It is working fine for me, last time I ran was Friday night.
> > > Eric
> > >
> > > -----Original Message-----
> > > From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> > > Sent: Monday, January 25, 2016 11:12 AM
> > > To: dev@trafodion.incubator.apache.org
> > > Subject: Test hanging
> > >
> > > Hi,
> > >
> > > I am trying to validate some changes before committing them and I am
> > > consistently seeing a hive test hang at the same statement. Even
> > > after backing my changes out the test hangs. Is this a known issue
> > > or likely still something wrong in my environement?
> > >
> > >
> > >
> > > >>-- insert some data and add one more partition
> > >
> > > >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
> > >
> > >
> > >
> > > insert overwrite table customer_ddl
> > >
> > > select
> > >
> > > c_customer_sk,
> > >
> > > c_customer_id,
> > >
> > > c_current_cdemo_sk,
> > >
> > > c_current_hdemo_sk,
> > >
> > > c_current_addr_sk,
> > >
> > > c_first_shipto_date_sk,
> > >
> > > c_first_sales_date_sk,
> > >
> > > c_salutation,
> > >
> > > c_first_name,
> > >
> > > c_last_name,
> > >
> > > c_preferred_cust_flag,
> > >
> > > c_birth_day,
> > >
> > > c_birth_month,
> > >
> > > c_birth_year,
> > >
> > > c_birth_country,
> > >
> > > c_login,
> > >
> > > c_email_address,
> > >
> > > c_last_review_date
> > >
> > > from customer
> > >
> > > where c_customer_sk < 20000
> > >
> > >
> > >
> > > --Hangs here
> > >
> > >
> > >
> > > I executed this test through the ./tools/runallsb from the
> > > sql/regress directory.
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Sean
> > >
> >
>
>
>
> --
> Regards, --Qifan
>
--
Regards, --Qifan
RE: Test hanging
Posted by Sean Broeder <se...@esgyn.com>.
Perhaps this property setting should be made default in
install_local_hadoop?
Thanks,
Sean
-----Original Message-----
From: Qifan Chen [mailto:qifan.chen@esgyn.com]
Sent: Tuesday, January 26, 2016 9:10 AM
To: dev <de...@trafodion.incubator.apache.org>
Subject: Re: Test hanging
Hi Sean,
Thank you for the tip. It helps solving another hung problem in my hive/orc
loading test.
Thanks --Qifan
On Mon, Jan 25, 2016 at 10:05 PM, Sean Broeder <se...@esgyn.com>
wrote:
> Thanks to the suggestion below my problem of tests hanging is solved.
>
> Much appreciated!
> Sean
>
> -----Original Message-----
> From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> Sent: Monday, January 25, 2016 11:15 AM
> To: 'dev@trafodion.incubator.apache.org'
> <de...@trafodion.incubator.apache.org>
> Subject: RE: Test hanging
>
> Thanks Hans,
> I'm trying a suggestion to add a property to the mapred-site.xml file - …
> <property>
> <name>mapreduce.framework.name</name>
> <value>local</value> == from yarn to local
> </property>
> …
>
> I've restarted all and am waiting to see if the condition hits again.
>
> Regards,
> Sean
>
> -----Original Message-----
> From: Hans Zeller [mailto:hans.zeller@esgyn.com]
> Sent: Monday, January 25, 2016 11:09 AM
> To: dev <de...@trafodion.incubator.apache.org>
> Subject: Re: Test hanging
>
> Hi Sean, this is probably related to MapReduce, this particular
> statement will start MapReduce jobs. You can check whether Yarn and
> the other required Hadoop components are up, or just try restarting
> your Hadoop environment.
> You can also look at the Yarn web page to see whether you have any
> stuck requests. If you use install_local_hadoop, open page
> $MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
>
> Hans
>
> On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com>
> wrote:
>
> > It is working fine for me, last time I ran was Friday night.
> > Eric
> >
> > -----Original Message-----
> > From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> > Sent: Monday, January 25, 2016 11:12 AM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Test hanging
> >
> > Hi,
> >
> > I am trying to validate some changes before committing them and I am
> > consistently seeing a hive test hang at the same statement. Even
> > after backing my changes out the test hangs. Is this a known issue
> > or likely still something wrong in my environement?
> >
> >
> >
> > >>-- insert some data and add one more partition
> >
> > >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
> >
> >
> >
> > insert overwrite table customer_ddl
> >
> > select
> >
> > c_customer_sk,
> >
> > c_customer_id,
> >
> > c_current_cdemo_sk,
> >
> > c_current_hdemo_sk,
> >
> > c_current_addr_sk,
> >
> > c_first_shipto_date_sk,
> >
> > c_first_sales_date_sk,
> >
> > c_salutation,
> >
> > c_first_name,
> >
> > c_last_name,
> >
> > c_preferred_cust_flag,
> >
> > c_birth_day,
> >
> > c_birth_month,
> >
> > c_birth_year,
> >
> > c_birth_country,
> >
> > c_login,
> >
> > c_email_address,
> >
> > c_last_review_date
> >
> > from customer
> >
> > where c_customer_sk < 20000
> >
> >
> >
> > --Hangs here
> >
> >
> >
> > I executed this test through the ./tools/runallsb from the
> > sql/regress directory.
> >
> >
> >
> > Thanks,
> >
> > Sean
> >
>
--
Regards, --Qifan
Re: Test hanging
Posted by Qifan Chen <qi...@esgyn.com>.
Hi Sean,
Thank you for the tip. It helps solving another hung problem in my
hive/orc loading test.
Thanks --Qifan
On Mon, Jan 25, 2016 at 10:05 PM, Sean Broeder <se...@esgyn.com>
wrote:
> Thanks to the suggestion below my problem of tests hanging is solved.
>
> Much appreciated!
> Sean
>
> -----Original Message-----
> From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> Sent: Monday, January 25, 2016 11:15 AM
> To: 'dev@trafodion.incubator.apache.org'
> <de...@trafodion.incubator.apache.org>
> Subject: RE: Test hanging
>
> Thanks Hans,
> I'm trying a suggestion to add a property to the mapred-site.xml file - …
> <property>
> <name>mapreduce.framework.name</name>
> <value>local</value> == from yarn to local
> </property>
> …
>
> I've restarted all and am waiting to see if the condition hits again.
>
> Regards,
> Sean
>
> -----Original Message-----
> From: Hans Zeller [mailto:hans.zeller@esgyn.com]
> Sent: Monday, January 25, 2016 11:09 AM
> To: dev <de...@trafodion.incubator.apache.org>
> Subject: Re: Test hanging
>
> Hi Sean, this is probably related to MapReduce, this particular statement
> will start MapReduce jobs. You can check whether Yarn and the other
> required
> Hadoop components are up, or just try restarting your Hadoop environment.
> You can also look at the Yarn web page to see whether you have any stuck
> requests. If you use install_local_hadoop, open page
> $MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
>
> Hans
>
> On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com>
> wrote:
>
> > It is working fine for me, last time I ran was Friday night.
> > Eric
> >
> > -----Original Message-----
> > From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> > Sent: Monday, January 25, 2016 11:12 AM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Test hanging
> >
> > Hi,
> >
> > I am trying to validate some changes before committing them and I am
> > consistently seeing a hive test hang at the same statement. Even
> > after backing my changes out the test hangs. Is this a known issue or
> > likely still something wrong in my environement?
> >
> >
> >
> > >>-- insert some data and add one more partition
> >
> > >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
> >
> >
> >
> > insert overwrite table customer_ddl
> >
> > select
> >
> > c_customer_sk,
> >
> > c_customer_id,
> >
> > c_current_cdemo_sk,
> >
> > c_current_hdemo_sk,
> >
> > c_current_addr_sk,
> >
> > c_first_shipto_date_sk,
> >
> > c_first_sales_date_sk,
> >
> > c_salutation,
> >
> > c_first_name,
> >
> > c_last_name,
> >
> > c_preferred_cust_flag,
> >
> > c_birth_day,
> >
> > c_birth_month,
> >
> > c_birth_year,
> >
> > c_birth_country,
> >
> > c_login,
> >
> > c_email_address,
> >
> > c_last_review_date
> >
> > from customer
> >
> > where c_customer_sk < 20000
> >
> >
> >
> > --Hangs here
> >
> >
> >
> > I executed this test through the ./tools/runallsb from the sql/regress
> > directory.
> >
> >
> >
> > Thanks,
> >
> > Sean
> >
>
--
Regards, --Qifan
RE: Test hanging
Posted by Sean Broeder <se...@esgyn.com>.
Thanks to the suggestion below my problem of tests hanging is solved.
Much appreciated!
Sean
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Monday, January 25, 2016 11:15 AM
To: 'dev@trafodion.incubator.apache.org'
<de...@trafodion.incubator.apache.org>
Subject: RE: Test hanging
Thanks Hans,
I'm trying a suggestion to add a property to the mapred-site.xml file - …
<property>
<name>mapreduce.framework.name</name>
<value>local</value> == from yarn to local
</property>
…
I've restarted all and am waiting to see if the condition hits again.
Regards,
Sean
-----Original Message-----
From: Hans Zeller [mailto:hans.zeller@esgyn.com]
Sent: Monday, January 25, 2016 11:09 AM
To: dev <de...@trafodion.incubator.apache.org>
Subject: Re: Test hanging
Hi Sean, this is probably related to MapReduce, this particular statement
will start MapReduce jobs. You can check whether Yarn and the other required
Hadoop components are up, or just try restarting your Hadoop environment.
You can also look at the Yarn web page to see whether you have any stuck
requests. If you use install_local_hadoop, open page
$MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
Hans
On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com> wrote:
> It is working fine for me, last time I ran was Friday night.
> Eric
>
> -----Original Message-----
> From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> Sent: Monday, January 25, 2016 11:12 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Test hanging
>
> Hi,
>
> I am trying to validate some changes before committing them and I am
> consistently seeing a hive test hang at the same statement. Even
> after backing my changes out the test hangs. Is this a known issue or
> likely still something wrong in my environement?
>
>
>
> >>-- insert some data and add one more partition
>
> >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
>
>
>
> insert overwrite table customer_ddl
>
> select
>
> c_customer_sk,
>
> c_customer_id,
>
> c_current_cdemo_sk,
>
> c_current_hdemo_sk,
>
> c_current_addr_sk,
>
> c_first_shipto_date_sk,
>
> c_first_sales_date_sk,
>
> c_salutation,
>
> c_first_name,
>
> c_last_name,
>
> c_preferred_cust_flag,
>
> c_birth_day,
>
> c_birth_month,
>
> c_birth_year,
>
> c_birth_country,
>
> c_login,
>
> c_email_address,
>
> c_last_review_date
>
> from customer
>
> where c_customer_sk < 20000
>
>
>
> --Hangs here
>
>
>
> I executed this test through the ./tools/runallsb from the sql/regress
> directory.
>
>
>
> Thanks,
>
> Sean
>
RE: Test hanging
Posted by Sean Broeder <se...@esgyn.com>.
Thanks Hans,
I'm trying a suggestion to add a property to the mapred-site.xml file -
…
<property>
<name>mapreduce.framework.name</name>
<value>local</value> == from yarn to local
</property>
…
I've restarted all and am waiting to see if the condition hits again.
Regards,
Sean
-----Original Message-----
From: Hans Zeller [mailto:hans.zeller@esgyn.com]
Sent: Monday, January 25, 2016 11:09 AM
To: dev <de...@trafodion.incubator.apache.org>
Subject: Re: Test hanging
Hi Sean, this is probably related to MapReduce, this particular statement
will start MapReduce jobs. You can check whether Yarn and the other required
Hadoop components are up, or just try restarting your Hadoop environment.
You can also look at the Yarn web page to see whether you have any stuck
requests. If you use install_local_hadoop, open page
$MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
Hans
On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com> wrote:
> It is working fine for me, last time I ran was Friday night.
> Eric
>
> -----Original Message-----
> From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> Sent: Monday, January 25, 2016 11:12 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Test hanging
>
> Hi,
>
> I am trying to validate some changes before committing them and I am
> consistently seeing a hive test hang at the same statement. Even
> after backing my changes out the test hangs. Is this a known issue or
> likely still something wrong in my environement?
>
>
>
> >>-- insert some data and add one more partition
>
> >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
>
>
>
> insert overwrite table customer_ddl
>
> select
>
> c_customer_sk,
>
> c_customer_id,
>
> c_current_cdemo_sk,
>
> c_current_hdemo_sk,
>
> c_current_addr_sk,
>
> c_first_shipto_date_sk,
>
> c_first_sales_date_sk,
>
> c_salutation,
>
> c_first_name,
>
> c_last_name,
>
> c_preferred_cust_flag,
>
> c_birth_day,
>
> c_birth_month,
>
> c_birth_year,
>
> c_birth_country,
>
> c_login,
>
> c_email_address,
>
> c_last_review_date
>
> from customer
>
> where c_customer_sk < 20000
>
>
>
> --Hangs here
>
>
>
> I executed this test through the ./tools/runallsb from the sql/regress
> directory.
>
>
>
> Thanks,
>
> Sean
>
Re: Test hanging
Posted by Hans Zeller <ha...@esgyn.com>.
Hi Sean, this is probably related to MapReduce, this particular statement
will start MapReduce jobs. You can check whether Yarn and the other
required Hadoop components are up, or just try restarting your Hadoop
environment. You can also look at the Yarn web page to see whether you have
any stuck requests. If you use install_local_hadoop, open page
$MY_SQROOT/sql/scripts/swurls.html to get to the Yarn GUI.
Hans
On Mon, Jan 25, 2016 at 10:13 AM, Eric Owhadi <er...@esgyn.com> wrote:
> It is working fine for me, last time I ran was Friday night.
> Eric
>
> -----Original Message-----
> From: Sean Broeder [mailto:sean.broeder@esgyn.com]
> Sent: Monday, January 25, 2016 11:12 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Test hanging
>
> Hi,
>
> I am trying to validate some changes before committing them and I am
> consistently seeing a hive test hang at the same statement. Even after
> backing my changes out the test hangs. Is this a known issue or likely
> still something wrong in my environement?
>
>
>
> >>-- insert some data and add one more partition
>
> >>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
>
>
>
> insert overwrite table customer_ddl
>
> select
>
> c_customer_sk,
>
> c_customer_id,
>
> c_current_cdemo_sk,
>
> c_current_hdemo_sk,
>
> c_current_addr_sk,
>
> c_first_shipto_date_sk,
>
> c_first_sales_date_sk,
>
> c_salutation,
>
> c_first_name,
>
> c_last_name,
>
> c_preferred_cust_flag,
>
> c_birth_day,
>
> c_birth_month,
>
> c_birth_year,
>
> c_birth_country,
>
> c_login,
>
> c_email_address,
>
> c_last_review_date
>
> from customer
>
> where c_customer_sk < 20000
>
>
>
> --Hangs here
>
>
>
> I executed this test through the ./tools/runallsb from the sql/regress
> directory.
>
>
>
> Thanks,
>
> Sean
>
RE: Test hanging
Posted by Eric Owhadi <er...@esgyn.com>.
It is working fine for me, last time I ran was Friday night.
Eric
-----Original Message-----
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Monday, January 25, 2016 11:12 AM
To: dev@trafodion.incubator.apache.org
Subject: Test hanging
Hi,
I am trying to validate some changes before committing them and I am
consistently seeing a hive test hang at the same statement. Even after
backing my changes out the test hangs. Is this a known issue or likely
still something wrong in my environement?
>>-- insert some data and add one more partition
>>sh regrhive.ksh -v -f $REGRTSTDIR/TEST005_b.hive.sql;
insert overwrite table customer_ddl
select
c_customer_sk,
c_customer_id,
c_current_cdemo_sk,
c_current_hdemo_sk,
c_current_addr_sk,
c_first_shipto_date_sk,
c_first_sales_date_sk,
c_salutation,
c_first_name,
c_last_name,
c_preferred_cust_flag,
c_birth_day,
c_birth_month,
c_birth_year,
c_birth_country,
c_login,
c_email_address,
c_last_review_date
from customer
where c_customer_sk < 20000
--Hangs here
I executed this test through the ./tools/runallsb from the sql/regress
directory.
Thanks,
Sean