Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1685

Print enhanced message when using table data which located on local file system occasionally on fully distributed mode.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Java Client, SQL Shell
    • Labels:
      None

      Description

      Tajo allows that the location of table would be set the path of local file system, for example, “file:///home/tajo/xyz”. When querying above table data on pseudo distributed mode, the query would finished successfully. Pseudo distributed mode for tajo means that TajoMaster and TajoWorker just run on the same host. But when querying the data on fully distribute mode, the query would failed because the data was’t located on all hosts for running TajoWorker. In this case, users would see ambiguous error message as follows.

      default> create external table table1 (
      >       id int,
      >       name text,
      >       score float,
      >       type text)
      >       using text with ('text.delimiter'='|') location 'file:///home/tajo/data.csv'
      > ;
      OK
      default> \d table1;
      
      table name: default.table1
      table uri: file:///home/tajo/data.csv
      store type: text
      number of rows: unknown
      volume: 60 B
      Options: 
      	'text.delimiter'='|'
      
      schema: 
      id	INT4
      name	TEXT
      score	FLOAT4
      type	TEXT
      
      
      default> select * from table1;
      id,  name,  score,  type
      -------------------------------
      1,  abc,  1.1,  a
      2,  def,  2.3,  b
      3,  ghi,  3.4,  c
      4,  jkl,  4.5,  d
      5,  mno,  5.6,  e
      (5 rows, 0.081 sec, 60 B selected)
      
      default> select count(*) from table1;
      ERROR: No error message
      

      It doesn’t seems easy for users to know the cause of the error. We need to print a well-defined message for avoiding users confusion.

        Attachments

          Activity

            People

            • Assignee:
              blrunner JaeHwa Jung
              Reporter:
              blrunner JaeHwa Jung
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: