> My goal is to create separate independent processing units (queries)
>that can then be composed into larger queries. Effectively something like:
Ah, modularization beyond a single statement. Views would be the right
thing there as a permanent abstraction.
I like CTEs during dev is because I ca
HI Cazen,
The location is present, just to simplify, I didnt paste the complete
create command;
The table is querable also.
Thanks,
Ravi
On Tue, Sep 15, 2015 at 4:44 PM, Cazen Lee wrote:
> External table can create without exact location or no location.
>
> So, I guess you didn't set the locat
External table can create without exact location or no location.
So, I guess you didn't set the location or it doesn't exist the file system
Did you set the location of table?
CREATE EXTERNAL TABLE IF NOT EXIST test_table
(
a STRING
)
LOCATION '*hdfs://aa:port/location*';
If you set the locat
Its an external table, hence I am only creating the table on the already
present data location.
On Tue, Sep 15, 2015 at 4:02 PM, Nitin Pawar
wrote:
> are you loading data in partitioned test_table after creating table and
> before repairing using MSCK ?
>
> On Tue, Sep 15, 2015 at 3:51 PM, ravi
are you loading data in partitioned test_table after creating table and
before repairing using MSCK ?
On Tue, Sep 15, 2015 at 3:51 PM, ravi teja wrote:
> The location is present in the filesystem.
>
> Thanks,
> Ravi
>
> On Tue, Sep 15, 2015 at 12:16 PM, Chetna C wrote:
>
>> Hi Ravi,
>> Plea
The location is present in the filesystem.
Thanks,
Ravi
On Tue, Sep 15, 2015 at 12:16 PM, Chetna C wrote:
> Hi Ravi,
> Please make sure the location mentioned while create table exists at
> the time of *'MSCK REPAIR'*. This error occurs, if location does not
> exists on fs.
>
> Thanks,
> Ch
On 15 September 2015 at 00:09, Gopal Vijayaraghavan
wrote:
> CTE
Thank you for the in depth reply Gopal. I've just had a quick try out of
CTEs but can't see how they address my original problem of decomposing a
query into separate independent units. It seems that the CTE definition ('
with' cla
