Yes Kylin doesn¹t import the hive table automatically. This need a load table action; It can be performed in two ways:
1. With Kylin web UI: a. Logon Kylin with a user id which has admin role; b. Click the ³table² tab, you would see an icon which looks like download something, click it. c. Enter the table name, and then click ³Sync²; 2. With Kylin REST API: https://github.com/KylinOLAP/Kylin/wiki/Restful-Service-Doc#load-hive-table s After that, the table¹s metadata will be saved in Kylin. Whenever there is a metadata change (like add a column) in the hive which need be updated to Cube, you need perform the above steps to syn the table into Kylin. Hope this answers your question. On 2/17/15, 5:29 AM, "Tero Paananen" <[email protected]> wrote: >On Mon, Feb 16, 2015 at 3:54 PM, Aaron Zimmerman ><[email protected]> wrote: >> Hi all, >> I¹m trying Kylin out and I can¹t get the tables I¹ve defined in hive >>to show up in the cube builder. Any ideas where to look or what I might >>be missing? >> >> >> When I open a hive shell on the Kylin host, I can 'show tables' and see >>them all. > >As far as I know, Kylin doesn't show you a list of Hive tables >anywhere. You have to know the name, and type it in the sync tables >prompt. > >-TPP
