Sorry, do not bother. I figured out - can be done by specifying
BLOCKCACHE=false at create table time.
From: Sumit Nigam <[email protected]>
To: Users Mail List Phoenix <[email protected]>
Sent: Thursday, November 5, 2015 1:58 PM
Subject: Block Cache
Hi,
Is there an easy way to completely turn off block cache for a specific table at
table creation time itself? Something like, CREATE TABLE X ( ..... )
BLOCK_CACHE=FALSE;
I could likely hint the queries during read time, but setting I'd like to turn
it off completely.
Thanks,Sumit