tajo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (TAJO-1610) Cannot find column when the same name is used for table and database
Date Wed, 02 Sep 2015 01:53:45 GMT

     [ https://issues.apache.org/jira/browse/TAJO-1610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hyunsik Choi updated TAJO-1610:
-------------------------------
    Priority: Critical  (was: Major)

> Cannot find column when the same name is used for table and database
> --------------------------------------------------------------------
>
>                 Key: TAJO-1610
>                 URL: https://issues.apache.org/jira/browse/TAJO-1610
>             Project: Tajo
>          Issue Type: Bug
>          Components: Planner/Optimizer
>            Reporter: Jihoon Son
>            Priority: Critical
>             Fix For: 0.11.0
>
>
> See the title.
> You can reproduce as follows:
> {noformat}
> tweets> CREATE EXTERNAL TABLE tweets (   coordinates TEXT,   favorited BOOL,   truncated
BOOL,   created_at TIMESTAMP,   id_str TEXT,   /*entrities RECORD (     urls ARRAY<TEXT>
  )*/   in_reply_to_user_id_str TEXT,   contributors TEXT,   text TEXT,   metadata RECORD
(     iso_language_code TEXT,     result_type TEXT   ),   retweet_count INTEGER,   in_reply_to_status_id_str
TEXT,   id TEXT,   geo TEXT,   retweeted BOOL,   in_reply_to_user_id TEXT,   place TEXT, 
 user RECORD (     profile_sidebar_fill_color TEXT,     profile_sidebar_border_color TEXT,
    profile_background_tile TEXT,     name TEXT,     profile_image_url TEXT,     created_at
TIMESTAMP,     location TEXT,     follow_request_sent TEXT,     profile_link_color TEXT, 
   is_translator BOOL,     id_str TEXT,     /*     entities RECORD (       url RECORD (  
    ),       description RECORD (       )     ), */     default_profile BOOL,     contributors_enabled
BOOL,     favourites_count INTEGER,     url TEXT,     profile_image_url_https TEXT,     utc_offset
INTEGER,     id BIGINT,     profile_use_background_image BOOL,     listed_count INTEGER, 
   profile_text_color TEXT,     lang TEXT,     followers_count INTEGER,     protected BOOL,
    notifications TEXT,     profile_background_image_url_https TEXT,     profile_background_color
TEXT,     verified TEXT,     geo_enabled TEXT,     time_zone TEXT,     description TEXT, 
   default_profile_image TEXT,     profile_background_image_url TEXT,     statuses_count INTEGER,
    friends_count INTEGER,     following TEXT,     show_all_inline_media BOOL,     screen_name
TEXT   ),   in_reply_to_screen_name TEXT,   source TEXT,   in_reply_to_status_id TEXT ) USING
JSON LOCATION 'file://.../Projects/twitter_201407221120.log';
> OK
> tweets> \d
> tweets
> tweets> \d tweets
> table name: tweets.tweets
> table path: file://.../Projects/twitter_201407221120.log
> store type: json
> number of rows: unknown
> volume: 151.2 MB
> Options: 
> 	'text.serde'='org.apache.tajo.storage.json.JsonLineSerDe'
> schema: 
> coordinates	TEXT
> favorited	BOOLEAN
> truncated	BOOLEAN
> created_at	TIMESTAMP
> id_str	TEXT
> in_reply_to_user_id_str	TEXT
> contributors	TEXT
> text	TEXT
> metadata	RECORD (iso_language_code TEXT, result_type TEXT)
> retweet_count	INT4
> in_reply_to_status_id_str	TEXT
> id	TEXT
> geo	TEXT
> retweeted	BOOLEAN
> in_reply_to_user_id	TEXT
> place	TEXT
> user	RECORD (profile_sidebar_fill_color TEXT, profile_sidebar_border_color TEXT, profile_background_tile
TEXT, name TEXT, profile_image_url TEXT, created_at TIMESTAMP, location TEXT, follow_request_sent
TEXT, profile_link_color TEXT, is_translator BOOLEAN, id_str TEXT, default_profile BOOLEAN,
contributors_enabled BOOLEAN, favourites_count INT4, url TEXT, profile_image_url_https TEXT,
utc_offset INT4, id INT8, profile_use_background_image BOOLEAN, listed_count INT4, profile_text_color
TEXT, lang TEXT, followers_count INT4, protected BOOLEAN, notifications TEXT, profile_background_image_url_https
TEXT, profile_background_color TEXT, verified TEXT, geo_enabled TEXT, time_zone TEXT, description
TEXT, default_profile_image TEXT, profile_background_image_url TEXT, statuses_count INT4,
friends_count INT4, following TEXT, show_all_inline_media BOOLEAN, screen_name TEXT)
> in_reply_to_screen_name	TEXT
> source	TEXT
> in_reply_to_status_id	TEXT
> tweets> select "text" from tweets limit 10;
> ERROR: column "tweets.tweets.text" does not exist
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message