sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Veena Basavaraj (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (SQOOP-1767) Sqoop2: commands in 5 minute demo docs are out-of-sync
Date Wed, 19 Nov 2014 15:09:34 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-1767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14217974#comment-14217974
] 

Veena Basavaraj edited comment on SQOOP-1767 at 11/19/14 3:08 PM:
------------------------------------------------------------------

I have tried that the show job -jid 1 also works.! 

{code}
sqoop:000> show job --jid 1
1 job(s) to show: 
Job with id 1 and name JOb1 (Enabled: true, Created by root at 11/17/14 4:33 AM, Updated by
root at 11/17/14 4:33 AM)
Using link id 2 and Connector id 2
  From database configuration
    Schema name: 
    Table name: users
    Table SQL statement: 
    Table column names: id
    Partition column name: id
    Null value allowed for the partition column: 
    Boundary query: 
  Throttling resources
    Extractors: 
    Loaders: 
  ToJob configuration
    Output format: 
    Compression format: 
    Custom compression format: 
    Output directory: hdfs://
sqoop:000> show job -j 1   
1 job(s) to show: 
Job with id 1 and name JOb1 (Enabled: true, Created by root at 11/17/14 4:33 AM, Updated by
root at 11/17/14 4:33 AM)
Using link id 2 and Connector id 2
  From database configuration
    Schema name: 
    Table name: users
    Table SQL statement: 
    Table column names: id
    Partition column name: id
    Null value allowed for the partition column: 
    Boundary query: 
  Throttling resources
    Extractors: 
    Loaders: 
  ToJob configuration
    Output format: 
    Compression format: 
    Custom compression format: 
    Output directory: hdfs://
sqoop:000> 
{code}

if you see the code it is clear, there is long form and short form for every one of these.
cid is long, c is short for connector id. 

show links should be supported since we now have a v1/links and v1/connectors api. 

http://vbsqoop-1.ent.cloudera.com:12000/sqoop/v1/links

Today if there is no linkId, it defaults to showing all.

{code}
sqoop:000> show link 
+----+------------+-----------+---------+
| Id |    Name    | Connector | Enabled |
+----+------------+-----------+---------+
| 1  | hdfsLink   | 1         | true    |
| 2  | MysqlLink  | 2         | true    |
| 3  | MySQlLink2 | 2         | true    |
+----+------------+-----------+---------+
sqoop:000> show link -l 1
1 link(s) to show: 
link with id 1 and name hdfsLink (Enabled: true, Created by root at 11/17/14 4:29 AM, Updated
by root at 11/17/14 4:29 AM)
Using Connector id 1
  Link configuration
    HDFS URI: hdfs://vbsqoop-1.ent.cloudera.com/user/root/job1
sqoop:000> 

{code}

Also for status
{code}
sqoop:000> status job -j 1
Submission details
Job ID: 1
Server URL: http://localhost:12000/sqoop/
Created by: null
Creation date: 2014-11-19 07:06:45 PST
Lastly updated by: null
2014-11-19 07:06:45 PST: NEVER_EXECUTED
sqoop:000> status job --jid 1
Submission details
Job ID: 1
Server URL: http://localhost:12000/sqoop/
Created by: null
Creation date: 2014-11-19 07:06:50 PST
Lastly updated by: null
2014-11-19 07:06:50 PST: NEVER_EXECUTED
sqoop:000>
{code}



was (Author: vybs):
I have tried that the show job -jid 1 also works.! 

{code}
sqoop:000> show job --jid 1
1 job(s) to show: 
Job with id 1 and name JOb1 (Enabled: true, Created by root at 11/17/14 4:33 AM, Updated by
root at 11/17/14 4:33 AM)
Using link id 2 and Connector id 2
  From database configuration
    Schema name: 
    Table name: users
    Table SQL statement: 
    Table column names: id
    Partition column name: id
    Null value allowed for the partition column: 
    Boundary query: 
  Throttling resources
    Extractors: 
    Loaders: 
  ToJob configuration
    Output format: 
    Compression format: 
    Custom compression format: 
    Output directory: hdfs://
sqoop:000> show job -j 1   
1 job(s) to show: 
Job with id 1 and name JOb1 (Enabled: true, Created by root at 11/17/14 4:33 AM, Updated by
root at 11/17/14 4:33 AM)
Using link id 2 and Connector id 2
  From database configuration
    Schema name: 
    Table name: users
    Table SQL statement: 
    Table column names: id
    Partition column name: id
    Null value allowed for the partition column: 
    Boundary query: 
  Throttling resources
    Extractors: 
    Loaders: 
  ToJob configuration
    Output format: 
    Compression format: 
    Custom compression format: 
    Output directory: hdfs://
sqoop:000> 
{code}

if you see the code it is clear, there is long form and short form for every one of these.
cid is long, c is short for connector id. 

show links should be supported since we now have a v1/links and v1/connectors api. 

http://vbsqoop-1.ent.cloudera.com:12000/sqoop/v1/links

Today if there is no linkId, it defaults to showing all.

{code}
sqoop:000> show link 
+----+------------+-----------+---------+
| Id |    Name    | Connector | Enabled |
+----+------------+-----------+---------+
| 1  | hdfsLink   | 1         | true    |
| 2  | MysqlLink  | 2         | true    |
| 3  | MySQlLink2 | 2         | true    |
+----+------------+-----------+---------+
sqoop:000> show link -l 1
1 link(s) to show: 
link with id 1 and name hdfsLink (Enabled: true, Created by root at 11/17/14 4:29 AM, Updated
by root at 11/17/14 4:29 AM)
Using Connector id 1
  Link configuration
    HDFS URI: hdfs://vbsqoop-1.ent.cloudera.com/user/root/job1
sqoop:000> 

{code}


> Sqoop2: commands in 5 minute demo docs are out-of-sync 
> -------------------------------------------------------
>
>                 Key: SQOOP-1767
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1767
>             Project: Sqoop
>          Issue Type: Improvement
>            Reporter: Qian Xu
>            Assignee: Qian Xu
>            Priority: Minor
>              Labels: newbie++
>             Fix For: 1.99.5
>
>         Attachments: SQOOP-1767.patch
>
>
> The commands in 5 minute demo docs are out-of-sync. {{show links}} should be {{show link}},
etc. All commands should be revised. 



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

Mime
View raw message