Assistance required in the following issue.
Have created hive table through spark data frame from the csv files that are in HDFS path.
After creating hive table, used the below query and result showing as zero records. But the same query is working fine in Hue and giving records count. Kindly let me know what is the issue here.
df = tbl(sc,sql(" SELECT * FROM table1 LIMIT 100"))
df %>% count()
Source: lazy query [?? x 1]
Thanks and Regards