Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
User-Agent: Microsoft-MacOutlook/14.5.9.151119
Date: Wed, 24 Feb 2016 16:26:39 -0800
Subject: Re: Anyway to avoid creating subdirectories by "Insert with
 =?EUC-KR?B?dW5pb26p9w==?=
From: Gopal Vijayaraghavan <gopalv@apache.org>
Sender: Gopal Vijayaraghavan <gopal@hortonworks.com>
To: "user@hive.apache.org" <user@hive.apache.org>
Message-ID: <D2F387AC.4183F%gopal@hortonworks.com>
Thread-Topic: Anyway to avoid creating subdirectories by "Insert with
 =?EUC-KR?B?dW5pb26p9w==?=
References: <BLU437-SMTP5FDF91AF817CF729B12B192A50@phx.gbl>
 <D2F298B6.4142E%gopal@hortonworks.com>
 <BLU436-SMTP12527AFFF239FDF2E4F0E6A92A50@phx.gbl>
In-Reply-To: <BLU436-SMTP12527AFFF239FDF2E4F0E6A92A50@phx.gbl>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

> SET mapred.input.dir.recursive=TRUE;
...
> Can we set above setting as tblProperties or Hive Table properties.

Not directly, those are MapReduce properties - they are not settable via
Hive tables.

That said, you can write your own SemanticAnalyzerHooks to do pretty much
anything you want like that.

You can use hooks to modify the job, after tables have been resolved.


Ideally such a hook should not modify the plan (much), because it's too
late to do it right.

But I sometimes prototype Hive optimizer features as Hooks, like this one.

https://github.com/t3rmin4t0r/captain-hook


Cheers,
Gopal