Reply
New Contributor
Posts: 4
Registered: ‎10-29-2014

impala odbc + tableau

Hi, guys)
I have a problem with the cloudera impala(CDH 5.2).
 
 
cloudera impala odbc driver 2.5.2
tableau desktop 8.2
impala 2.0
 
Report a Tableau was showing this error:
 
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : IllegalStateException: Illegal reference to non-materialized tuple: tid=4
 
Сan you explain why?
Highlighted
Cloudera Employee
Posts: 27
Registered: ‎09-27-2013

Re: impala odbc tableau

This looks like an issue in Impala. Can you provide the query that was run
when this happened? You can find the
query in the debug webpage of the impalad the query was sent to (or the
impalad INFO log for that machine).

New Contributor
Posts: 4
Registered: ‎10-29-2014

Re: impala odbc tableau

Thanks for the reply, Nong!

 

SELECT `custom_sql_query`.`city` AS `none_city_nk`,
  `custom_sql_query`.`date_dt`   AS `none_date_dt_ok`,
  `custom_sql_query`.`isp`       AS `none_isp_nk`,
  AVG((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `avg_calculation_5120823120155293_ok`
FROM
  (SELECT `f_wot_network_quality_ipr_agg`.`dt`         AS `dt`,
    `f_wot_network_quality_ipr_agg`.`batch_count`      AS `batch_count`,
    `f_wot_network_quality_ipr_agg`.`city`             AS `city`,
    `f_wot_network_quality_ipr_agg`.`region`           AS `region`,
    `f_wot_network_quality_ipr_agg`.`delay`            AS `delay`,
    `f_wot_network_quality_ipr_agg`.`fromip`           AS `fromip`,
    `f_wot_network_quality_ipr_agg`.`isp`              AS `isp`,
    `f_wot_network_quality_ipr_agg`.`packets_received` AS `packets_received`,
    `f_wot_network_quality_ipr_agg`.`packets_sent`     AS `packets_sent`,
    `f_wot_network_quality_ipr_agg`.`packets_resent`   AS `packets_resent`,
    `f_wot_network_quality_ipr_agg`.`date_dt`          AS `date_dt`,
    `f_wot_network_quality_ipr_agg`.`toip`             AS `toip`,
    `d_peripheries`.`periphery_id`                     AS `periphery_id`,
    `dim_countries`.`country_name`                     AS `country_name`
  FROM `dw_pr`.`f_wot_network_quality_ipr_agg` `f_wot_network_quality_ipr_agg`
  JOIN `dw_pr`.`d_peripheries` `d_peripheries`
  ON (`f_wot_network_quality_ipr_agg`.`periphery_nkey` = `d_peripheries`.`periphery_nkey`)
  JOIN `dw_pr`.`dim_countries` `dim_countries`
  ON (`f_wot_network_quality_ipr_agg`.`country_code_3_letter` = `dim_countries`.`country_code_3_letter`)
  WHERE `periphery_id`                                        =6
  AND `dt`                                                    > days_add(CURRENT_TIMESTAMP(),-1)
  ) `custom_sql_query`
WHERE false
GROUP BY 1,
  2,
  3
  ---



SELECT `custom_sql_query`.`fromip`      AS `none_fromip_nk`,
  `custom_sql_query`.`toip`             AS `none_toip_nk`,
  SUM(`custom_sql_query`.`batch_count`) AS `temp_tc___2391220405__0_`,
  AVG((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `avg_calculation_5120823120155293_ok`,
  COUNT((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `cnt_calculation_5120823120155293_ok`,
  SUM((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `sum_calculation_5120823120155293_ok`
FROM
  (SELECT `f_wot_network_quality_ipr_agg`.`dt`         AS `dt`,
    `f_wot_network_quality_ipr_agg`.`batch_count`      AS `batch_count`,
    `f_wot_network_quality_ipr_agg`.`city`             AS `city`,
    `f_wot_network_quality_ipr_agg`.`region`           AS `region`,
    `f_wot_network_quality_ipr_agg`.`delay`            AS `delay`,
    `f_wot_network_quality_ipr_agg`.`fromip`           AS `fromip`,
    `f_wot_network_quality_ipr_agg`.`isp`              AS `isp`,
    `f_wot_network_quality_ipr_agg`.`packets_received` AS `packets_received`,
    `f_wot_network_quality_ipr_agg`.`packets_sent`     AS `packets_sent`,
    `f_wot_network_quality_ipr_agg`.`packets_resent`   AS `packets_resent`,
    `f_wot_network_quality_ipr_agg`.`date_dt`          AS `date_dt`,
    `f_wot_network_quality_ipr_agg`.`toip`             AS `toip`,
    `d_peripheries`.`periphery_id`                     AS `periphery_id`,
    `dim_countries`.`country_name`                     AS `country_name`
  FROM `dw_pr`.`f_wot_network_quality_ipr_agg` `f_wot_network_quality_ipr_agg`
  JOIN `dw_pr`.`d_peripheries` `d_peripheries`
  ON (`f_wot_network_quality_ipr_agg`.`periphery_nkey` = `d_peripheries`.`periphery_nkey`)
  JOIN `dw_pr`.`dim_countries` `dim_countries`
  ON (`f_wot_network_quality_ipr_agg`.`country_code_3_letter` = `dim_countries`.`country_code_3_letter`)
  WHERE `periphery_id`                                        =11
  AND `dt`                                                    > days_add(CURRENT_TIMESTAMP(),-1)
  ) `custom_sql_query`
WHERE false
GROUP BY 1,
  2
---



SELECT `custom_sql_query`.`city`        AS `none_city_nk`,
  `custom_sql_query`.`isp`              AS `none_isp_nk`,
  SUM(`custom_sql_query`.`batch_count`) AS `temp_tc___2391220405__0_`,
  AVG((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `avg_calculation_5120823120155293_ok`,
  COUNT((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `cnt_calculation_5120823120155293_ok`,
  SUM((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `sum_calculation_5120823120155293_ok`
FROM
  (SELECT `f_wot_network_quality_ipr_agg`.`dt`         AS `dt`,
    `f_wot_network_quality_ipr_agg`.`batch_count`      AS `batch_count`,
    `f_wot_network_quality_ipr_agg`.`city`             AS `city`,
    `f_wot_network_quality_ipr_agg`.`region`           AS `region`,
    `f_wot_network_quality_ipr_agg`.`delay`            AS `delay`,
    `f_wot_network_quality_ipr_agg`.`fromip`           AS `fromip`,
    `f_wot_network_quality_ipr_agg`.`isp`              AS `isp`,
    `f_wot_network_quality_ipr_agg`.`packets_received` AS `packets_received`,
    `f_wot_network_quality_ipr_agg`.`packets_sent`     AS `packets_sent`,
    `f_wot_network_quality_ipr_agg`.`packets_resent`   AS `packets_resent`,
    `f_wot_network_quality_ipr_agg`.`date_dt`          AS `date_dt`,
    `f_wot_network_quality_ipr_agg`.`toip`             AS `toip`,
    `d_peripheries`.`periphery_id`                     AS `periphery_id`,
    `dim_countries`.`country_name`                     AS `country_name`
  FROM `dw_pr`.`f_wot_network_quality_ipr_agg` `f_wot_network_quality_ipr_agg`
  JOIN `dw_pr`.`d_peripheries` `d_peripheries`
  ON (`f_wot_network_quality_ipr_agg`.`periphery_nkey` = `d_peripheries`.`periphery_nkey`)
  JOIN `dw_pr`.`dim_countries` `dim_countries`
  ON (`f_wot_network_quality_ipr_agg`.`country_code_3_letter` = `dim_countries`.`country_code_3_letter`)
  WHERE `periphery_id`                                        =11
  AND `dt`                                                    > days_add(CURRENT_TIMESTAMP(),-1)
  ) `custom_sql_query`
WHERE false
GROUP BY 1,
  2

 it happened when we upgraded from impala 1.4  to impala 2.0

New Contributor
Posts: 4
Registered: ‎10-29-2014

Re: impala odbc tableau

These requests are sent Tableau desktop v8.2.

in impala 1.4 these queries worked