[
https://issues.apache.org/jira/browse/TAJO-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14510676#comment-14510676
]
ASF GitHub Bot commented on TAJO-1580:
--------------------------------------
GitHub user eminency opened a pull request:
https://github.com/apache/tajo/pull/552
TAJO-1580: Error line number is incorrect
Modified to avoid adding useless new line characters
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/eminency/tajo TAJO-1580
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/552.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #552
----
commit ddac430e49b6546586613f3e5ae259d299e2e8a3
Author: Jongyoung Park <[email protected]>
Date: 2015-04-24T08:37:36Z
Modified to avoid adding useless new line characters
----
> Error line number is incorrect
> ------------------------------
>
> Key: TAJO-1580
> URL: https://issues.apache.org/jira/browse/TAJO-1580
> Project: Tajo
> Issue Type: Bug
> Components: parser
> Affects Versions: 0.10.0
> Reporter: Jongyoung Park
> Assignee: Jongyoung Park
> Attachments: TAJO-1580.patch
>
>
> For next sql as an example,
> {code:sql}
> SELECT d_date_sk ss_sold_date_sk,
> t_time_sk ss_sold_time_sk,
> i_item_sk ss_item_sk,
> c_customer_sk ss_customer_sk,
> c_current_cdemo_sk ss_cdemo_sk,
> c_current_hdemo_sk ss_hdemo_sk,
> c_current_addr_sk ss_addr_sk,
> s_store_sk ss_store_sk,
> p_promo_sk ss_promo_sk,
> purc_purchase_id ss_ticket_number,
> plin_quantity ss_quantity,
> i_wholesale_cost ss_wholesale_cost,
> i_current_price ss_list_price,
> plin_sale_price ss_sales_price,
> (i_current_price-plin_sale_price)*plin_quantity ss_ext_discount_amt,
> plin_sale_price * plin_quantity ss_ext_sales_price,
> i_wholesale_cost * plin_quantity ss_ext_wholesale_cost, i_current_price *
> plin_quantity ss_ext_list_price, i_current_price * s_tax_precentage
> ss_ext_tax, plin_coupon_amt ss_coupon_amt,
> (plin_sale_price * plin_quantity)-plin_coupon_amt ss_net_paid,
> ((plin_sale_price * plin_quantity)-plin_coupon_amt)*(1+s_tax_precentage)
> ss_net_paid_inc_tax, ((plin_sale_price *
> plin_quantity)-plin_coupon_amt)-(plin_quantity*i_wholesale_cost)
> ss_net_profit
> FROM s_purchase
> LEFTT OUTER JOIN customer ON (purc_customer_id = c_customer_id)
> LEFT OUTER JOIN store ON (purc_store_id = s_store_id)
> LEFT OUTER JOIN date_dim ON (cast(purc_purchase_date as date) = d_date)
> LEFT OUTER JOIN time_dim ON (PURC_PURCHASE_TIME = t_time)
> JOIN s_purchase_lineitem ON (purc_purchase_id = plin_purchase_id)
> LEFT OUTER JOIN promotion ON plin_promotion_id = p_promo_id
> LEFT OUTER JOIN item ON plin_item_id = i_item_id
> WHERE purc_purchase_id = plin_purchase_id
> AND i_rec_end_date is NULL
> AND s_rec_end_date is NULL;
> {code}
> error message is like this :
> {quote}
> ERROR: mismatched input 'OUTER' expecting {<EOF>, EXCEPT, GROUP, HAVING,
> INTERSECT, LIMIT, ORDER, UNION, WHERE, WINDOW, ';', ','}
> LINE 39:8 LEFTT OUTER JOIN customer ON (purc_customer_id = c_customer_id)
> {quote}
> But the error line is 20, not 39.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
