Re: Error with flush_length File in Orc, in hive 2.1.0 and mr execution engine.

2016-10-26 Thread satyajit vegesna
ting_id = ml.id left > outer join attribute a on a.id = ml.standard_status > > Eugene > > From: satyajit vegesna > Date: Wednesday, October 26, 2016 at 2:14 PM > To: "u...@hive.apache.org" , Eugene Koifman < > ekoif...@hortonworks.com> > Cc: "dev@hiv

Re: Error with flush_length File in Orc, in hive 2.1.0 and mr execution engine.

2016-10-26 Thread satyajit vegesna
perator > limit: -1 > Processor Tree: > ListSink > > Any suggestion in debugging this issue is appreciated. > > > Regards, > Satyajit. > > > > > On Wed, Oct 26, 2016 at 3:34 PM, Eugene Koifman > wrote: > >> If you can run this, then it’s s

Re: Error with flush_length File in Orc, in hive 2.1.0 and mr execution engine.

2016-10-26 Thread satyajit vegesna
PFB EXPLAIN PLAN from hive, and query has issues at stage-14, i have also run another query which also fail in stage, *Map Reduce Local Work.* STAGE DEPENDENCIES: Stage-13 is a root stage , consists of Stage-1 Stage-1 Stage-10 depends on stages: Stage-1 , consists of Stage-15, Stage-2 Sta

Re: Error with flush_length File in Orc, in hive 2.1.0 and mr execution engine.

2016-10-26 Thread satyajit vegesna
Hi Eugene, PFB Transaction table in green and parquet tables in yellow, INSERT INTO access_logs.crawlstats_dpp PARTITION(day="2016-10-23") select pra.url as prUrl,pra.url_type as urlType,CAST(pra.created_at AS timestamp) as prCreated, CAST(pra.updated_at AS timestamp) as prUpdated, CAST(ml.create

Re: Error with flush_length File in Orc, in hive 2.1.0 and mr execution engine.

2016-10-25 Thread Eugene Koifman
Which of your tables are are transactional? Can you provide the DDL? I don’t think “File does not exist” error is causing your queries to fail. It’s an INFO level msg. There should be some other error. Eugene From: satyajit vegesna mailto:satyajit.apas...@gmail.com>> Reply-To: "u...@hive.ap