also try to remove "transactional"='true'? Best, Kurt
On Wed, Mar 18, 2020 at 5:54 PM [email protected] < [email protected]> wrote: > > Tried again. Even i remove the "clustered by (robot_id) into 3 buckets" > statement, no result from flink sql-client > > Thanks, > Lei > > ------------------------------ > [email protected] > > *From:* Kurt Young <[email protected]> > *Date:* 2020-03-18 17:41 > *To:* [email protected]; lirui <[email protected]> > *CC:* user <[email protected]> > *Subject:* Re: flink sql-client read hive orc table no result > My guess is we haven't support hive bucket table yet. > cc Rui Li for confirmation. > > Best, > Kurt > > > On Wed, Mar 18, 2020 at 5:19 PM [email protected] < > [email protected]> wrote: > >> Hive table store as orc format: >> CREATE TABLE `robot_tr`(`robot_id` int, `robot_time` bigint, >> `linear_velocity` double, `track_side_error` int) >> partitioned by (warehouseid STRING) clustered by (robot_id) into 3 >> buckets >> stored as orc tblproperties("transactional"='true'); >> >> Under hive client, insert into one record and then select there will be >> the result to the console. >> >> But under flink sql-client, when select * from robot_tr, there's no >> result? >> >> Any insight on this? >> >> Thanks, >> Lei >> >> ------------------------------ >> [email protected] >> >>
