That is good; ³,² is in the DETECT_DELIMS list, will be detected by Kylin;
On 2/25/15, 5:40 PM, "Jakob Stengård" <[email protected]> wrote: >Hi. >It seems to be working now, im using > >ROW FORMAT DELIMITED FIELDS TERMINATED BY "," ESCAPED BY '\\'; > > >Sorry for bothering you. >/J > >On Wed, Feb 25, 2015 at 10:24 AM, Jakob Stengård ><[email protected]> >wrote: > >> I get the following error when trying to build a cube with dimensions: >> >> [QuartzScheduler_Worker-1]:[2015-02-25 >> >>10:12:23,362][ERROR][com.kylinolap.job.hadoop.dict.CreateDictionaryJob.ru >>n(CreateDictionaryJob.java:55)] >> - Bad hive table row, TableDesc [name=TESTDATA_TIME] expect 5 columns, >>but >> got [2012-07-30 08:56:01.776 2012 7 30 8] >> java.lang.IllegalStateException: Bad hive table row, TableDesc >> [name=TESTDATA_TIME] expect 5 columns, but got [2012-07-30 08:56:01.776 >> 2012 7 30 8] >> at >> >>com.kylinolap.dict.lookup.SnapshotTable.takeSnapshot(SnapshotTable.java:6 >>8) >> at >> >>com.kylinolap.dict.lookup.SnapshotManager.buildSnapshot(SnapshotManager.j >>ava:94) >> at >> com.kylinolap.cube.CubeManager.buildSnapshotTable(CubeManager.java:208) >> at ... >> >> >> What format do i need to have dim tables in? >> I've tried ORC, TEXTFILE and SEQUENCEFILE so far, but building the >> dictionary doesn't seem >> to work with any of those. >> >> Best regards >> /Jakob Stengård >>
