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.run(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:68) > at > com.kylinolap.dict.lookup.SnapshotManager.buildSnapshot(SnapshotManager.java: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 >
