[
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)
