Thanks, its worked .!!
On Sat, Feb 20, 2016 at 8:18 PM, Divya Gehlot
wrote:
> Yes Gabriel is correct ..
> Even I got into same issue and it got resolved by MSCK repair table
> .command
> On Feb 20, 2016 12:35 AM, "Gabriel Balan"
> wrote:
>
>> Hi
>>
>> It's not enough to make dirs in hdfs.
Compaction would have been triggered automatically as following properties
already set in *hive-site.xml*. and also *NO_AUTO_COMPACTION* property not
been set for these tables.
hive.compactor.initiator.on
true
hive.compactor.worker.threads
1
Do
Hi Varadharajan,
Thanks for your response.
Yes it is transnational table; See below *show create table. *
Table hardly have 3 records , and after triggering minor compaction on
tables , it start showing results on spark SQL.
> *ALTER TABLE hivespark COMPACT 'major';*
> *show create table hiv
Hi,
I have observed that Spark SQL is not returning records for hive bucketed
ORC tables on HDP.
On spark SQL , I am able to list all tables , but queries on hive bucketed
tables are not returning records.
I have also tried the same for non-bucketed hive tables. it is working fine.
Same is
