Hi, i'm trying to connect tableau desktop 9.2 to spark sql. i'm using this guide http://samx18.io/blog/2015/09/05/tableau-spark-hive.html but on last step, then i'm try to get the contents of the table i'm getting only rows count and empty table.
hadoop 2.6 hive 1.21 spark 1.4.1 tableau desktop 9.2 Simba Spark ODBC Driver 1.0 (64-bit) thriftserver log 16/01/26 17:57:24 INFO SparkExecuteStatementOperation: Running query 'SELECT 1 AS `number_of_records` FROM `default`.`event_96720107` `event_96720107` LIMIT 10' 16/01/26 17:57:24 INFO ParseDriver: Parsing command: SELECT 1 AS `number_of_records` FROM `default`.`event_96720107` `event_96720107` LIMIT 10 16/01/26 17:57:24 INFO ParseDriver: Parse Completed 16/01/26 17:57:24 INFO HiveMetaStore: 2: get_table : db=default tbl=event_96720107 16/01/26 17:57:24 INFO audit: ugi=hduser ip=unknown-ip-addr cmd=get_table : db=default tbl=event_96720107 16/01/26 17:57:24 INFO MemoryStore: ensureFreeSpace(400328) called with curMem=1356967, maxMem=278019440 16/01/26 17:57:24 INFO MemoryStore: Block broadcast_26 stored as values in memory (estimated size 390.9 KB, free 263.5 MB) 16/01/26 17:57:24 INFO MemoryStore: ensureFreeSpace(36040) called with curMem=1757295, maxMem=278019440 16/01/26 17:57:24 INFO MemoryStore: Block broadcast_26_piece0 stored as bytes in memory (estimated size 35.2 KB, free 263.4 MB) 16/01/26 17:57:24 INFO BlockManagerInfo: Added broadcast_26_piece0 in memory on 192.168.245.128:43526 (size: 35.2 KB, free: 265.0 MB) 16/01/26 17:57:24 INFO SparkContext: Created broadcast 26 from Spark JDBC Server Query 16/01/26 17:57:24 INFO FileInputFormat: Total input paths to process : 1 16/01/26 17:57:24 INFO SparkContext: Starting job: Spark JDBC Server Query 16/01/26 17:57:24 INFO DAGScheduler: Got job 14 (Spark JDBC Server Query) with 1 output partitions (allowLocal=false) 16/01/26 17:57:24 INFO DAGScheduler: Final stage: ResultStage 14(Spark JDBC Server Query) 16/01/26 17:57:24 INFO DAGScheduler: Parents of final stage: List() 16/01/26 17:57:24 INFO DAGScheduler: Missing parents: List() 16/01/26 17:57:24 INFO DAGScheduler: Submitting ResultStage 14 (MapPartitionsRDD[84] at Spark JDBC Server Query), which has no missing parents 16/01/26 17:57:24 INFO MemoryStore: ensureFreeSpace(16768) called with curMem=1793335, maxMem=278019440 16/01/26 17:57:24 INFO MemoryStore: Block broadcast_27 stored as values in memory (estimated size 16.4 KB, free 263.4 MB) 16/01/26 17:57:24 INFO MemoryStore: ensureFreeSpace(7945) called with curMem=1810103, maxMem=278019440 16/01/26 17:57:24 INFO MemoryStore: Block broadcast_27_piece0 stored as bytes in memory (estimated size 7.8 KB, free 263.4 MB) 16/01/26 17:57:24 INFO BlockManagerInfo: Added broadcast_27_piece0 in memory on 192.168.245.128:43526 (size: 7.8 KB, free: 265.0 MB) 16/01/26 17:57:24 INFO SparkContext: Created broadcast 27 from broadcast at DAGScheduler.scala:874 16/01/26 17:57:24 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 14 (MapPartitionsRDD[84] at Spark JDBC Server Query) 16/01/26 17:57:24 INFO TaskSchedulerImpl: Adding task set 14.0 with 1 tasks 16/01/26 17:57:24 INFO TaskSetManager: Starting task 0.0 in stage 14.0 (TID 14, 192.168.245.128, ANY, 1448 bytes) 16/01/26 17:57:24 INFO BlockManagerInfo: Added broadcast_27_piece0 in memory on 192.168.245.128:49810 (size: 7.8 KB, free: 265.0 MB) 16/01/26 17:57:24 INFO BlockManagerInfo: Added broadcast_26_piece0 in memory on 192.168.245.128:49810 (size: 35.2 KB, free: 265.0 MB) 16/01/26 17:57:24 INFO TaskSetManager: Finished task 0.0 in stage 14.0 (TID 14) in 89 ms on 192.168.245.128 (1/1) 16/01/26 17:57:24 INFO TaskSchedulerImpl: Removed TaskSet 14.0, whose tasks have all completed, from pool 16/01/26 17:57:24 INFO DAGScheduler: ResultStage 14 (Spark JDBC Server Query) finished in 0.088 s 16/01/26 17:57:24 INFO DAGScheduler: Job 14 finished: Spark JDBC Server Query, took 0.105733 s 16/01/26 17:57:24 INFO StatsReportListener: Finished stage: org.apache.spark.scheduler.StageInfo@108a7 16/01/26 17:57:24 INFO SparkExecuteStatementOperation: Result Schema: ArrayBuffer(number_of_records#745) 16/01/26 17:57:24 INFO SparkExecuteStatementOperation: Result Schema: ArrayBuffer(number_of_records#745) 16/01/26 17:57:24 INFO StatsReportListener: task runtime:(count: 1, mean: 89.000000, stdev: 0.000000, max: 89.000000, min: 89.000000) 16/01/26 17:57:24 INFO StatsReportListener: 0% 5% 10% 25% 50% 75% 90% 95% 100% 16/01/26 17:57:24 INFO StatsReportListener: 89.0 ms 89.0 ms 89.0 ms 89.0 ms 89.0 ms 89.0 ms 89.0 ms 89.0 ms 89.0 ms 16/01/26 17:57:24 INFO StatsReportListener: task result size:(count: 1, mean: 1925.000000, stdev: 0.000000, max: 1925.000000, min: 1925.000000) 16/01/26 17:57:24 INFO StatsReportListener: 0% 5% 10% 25% 50% 75% 90% 95% 100% 16/01/26 17:57:24 INFO StatsReportListener: 1925.0 B 1925.0 B 1925.0 B 1925.0 B 1925.0 B 1925.0 B 1925.0 B 1925.0 B 1925.0 B 16/01/26 17:57:24 INFO StatsReportListener: executor (non-fetch) time pct: (count: 1, mean: 64.044944, stdev: 0.000000, max: 64.044944, min: 64.044944) 16/01/26 17:57:24 INFO StatsReportListener: 0% 5% 10% 25% 50% 75% 90% 95% 100% 16/01/26 17:57:24 INFO StatsReportListener: 64 % 64 % 64 % 64 % 64 % 64 % 64 % 64 % 64 % 16/01/26 17:57:24 INFO StatsReportListener: other time pct: (count: 1, mean: 35.955056, stdev: 0.000000, max: 35.955056, min: 35.955056) 16/01/26 17:57:24 INFO StatsReportListener: 0% 5% 10% 25% 50% 75% 90% 95% 100% 16/01/26 17:57:24 INFO StatsReportListener: 36 % 36 % 36 % 36 % 36 % 36 % 36 % 36 % 36 % 16/01/26 17:57:24 INFO SparkExecuteStatementOperation: Result Schema: ArrayBuffer(number_of_records#745) ----------------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org
