Probably you'll need Pig embedding:
For doing some logic that is not MapReduce and depends on you Pig's output.
For loading data to the created tables, you can take a look at HCatalog,
though I am not sure whether your very old version of the Hadoop distro
On Thu, Sep 26, 2013 at 10:49 AM, Swaroop Patra <[EMAIL PROTECTED]>wrote:
> Hi All,
> I have a requirement to create hive tables dynamically from pig script.
> Idea is while executing pig script we generate some intermediate data which
> we want to store in to hive tables. Schema for this data may vary for each
> execution. I am looking for a way in which I can create hive tables
> dynamically from pig script and load data to those tables from pig script.
> Is this possible? Please help.
> Hadoop version - 0.20.2-cdh3u2
> Pig version - 0.9.2
> Hive version - 0.8.0
> Thanks & Regards,