You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Pariksheet Barapatre <pb...@gmail.com> on 2014/11/13 13:50:02 UTC

How to use Hints in Phoenix queries

Hi All,

Want to use NO_CACHE Hint , how to use it .

Any example or documentation ?

http://phoenix.apache.org/language/index.html#cache_hint does not help
really.

UPSERT INTO TABLE1
SELECT * from TABLE2.

How to use cache hint here..



Cheers,
Pari

Re: How to use Hints in Phoenix queries

Posted by Eli Levine <el...@gmail.com>.

You'd use with with a SELECT statement like this:

SELECT /*+ NO_CACHE */ COUNT(*) FROM TABLE1;

Eli

On Thu, Nov 13, 2014 at 4:50 AM, Pariksheet Barapatre <pb...@gmail.com>
wrote:

> Hi All,
>
> Want to use NO_CACHE Hint , how to use it .
>
> Any example or documentation ?
>
> http://phoenix.apache.org/language/index.html#cache_hint does not help
> really.
>
> UPSERT INTO TABLE1
> SELECT * from TABLE2.
>
> How to use cache hint here..
>
>
>
> Cheers,
> Pari
>

Re: How to use Hints in Phoenix queries

Posted by Eli Levine <el...@gmail.com>.

You'd use with with a SELECT statement like this:

SELECT /*+ NO_CACHE */ COUNT(*) FROM TABLE1;

Eli

On Thu, Nov 13, 2014 at 4:50 AM, Pariksheet Barapatre <pb...@gmail.com>
wrote:

> Hi All,
>
> Want to use NO_CACHE Hint , how to use it .
>
> Any example or documentation ?
>
> http://phoenix.apache.org/language/index.html#cache_hint does not help
> really.
>
> UPSERT INTO TABLE1
> SELECT * from TABLE2.
>
> How to use cache hint here..
>
>
>
> Cheers,
> Pari
>