Sqoop Syntax error, unexpected tIdentifier

up vote
1
down vote

favorite

I'm trying to load MySQL table to hbase using sqoop. I'm using the below command but it is showing unexpected tIdentifier error. Please help.

sqoop import --connect jdbc:mysql://localhost/manideep --username root --password cloudera --table sample --hbase-table H_LOAN --column-family CD --hbase-row-key id -m 1

edited Nov 13 at 4:42

Zain Farooq

1,5502925

asked Nov 13 at 4:39

Manideep Reddy N

135

add a comment |

up vote
1
down vote

favorite

I'm trying to load MySQL table to hbase using sqoop. I'm using the below command but it is showing unexpected tIdentifier error. Please help.

sqoop import --connect jdbc:mysql://localhost/manideep --username root --password cloudera --table sample --hbase-table H_LOAN --column-family CD --hbase-row-key id -m 1

edited Nov 13 at 4:42

Zain Farooq

1,5502925

asked Nov 13 at 4:39

Manideep Reddy N

135

add a comment |

up vote
1
down vote

favorite

I'm trying to load MySQL table to hbase using sqoop. I'm using the below command but it is showing unexpected tIdentifier error. Please help.

sqoop import --connect jdbc:mysql://localhost/manideep --username root --password cloudera --table sample --hbase-table H_LOAN --column-family CD --hbase-row-key id -m 1

edited Nov 13 at 4:42

Zain Farooq

1,5502925

asked Nov 13 at 4:39

Manideep Reddy N

135

I'm trying to load MySQL table to hbase using sqoop. I'm using the below command but it is showing unexpected tIdentifier error. Please help.

sqoop import --connect jdbc:mysql://localhost/manideep --username root --password cloudera --table sample --hbase-table H_LOAN --column-family CD --hbase-row-key id -m 1

mysql hadoop hbase bigdata sqoop

edited Nov 13 at 4:42

Zain Farooq

1,5502925

asked Nov 13 at 4:39

Manideep Reddy N

135

edited Nov 13 at 4:42

Zain Farooq

1,5502925

asked Nov 13 at 4:39

Manideep Reddy N

135

edited Nov 13 at 4:42

Zain Farooq

1,5502925

edited Nov 13 at 4:42

Zain Farooq

1,5502925

edited Nov 13 at 4:42

Zain Farooq

1,5502925

asked Nov 13 at 4:39

Manideep Reddy N

135

asked Nov 13 at 4:39

Manideep Reddy N

135

asked Nov 13 at 4:39

Manideep Reddy N

135

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

accepted

Using the following command has worked for me to achieve hbase table import in Sgoop:

sqoop import --connect "jdbc:mysql://localhost/manideep" --username <username> --password ****** --table <mysql-table-name> --columns "column1,colmn2,column3" --hbase-table <hbase-table-name> --column-family <hbase-table-column-family> --hbase-row-key <row-key-column-name> -m 1

If the solution does not work, please post the exact issue (exception details) you have faced.

edited Nov 13 at 6:51

dev ツ

6,83273781

answered Nov 13 at 5:09

Ajar

948

Thanks for the reply. I was running the command under hbase shell earlier. I tried running outside the shell and it worked.
– Manideep Reddy N
Nov 13 at 5:57

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53273918%2fsqoop-syntax-error-unexpected-tidentifier%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

accepted

Using the following command has worked for me to achieve hbase table import in Sgoop:

If the solution does not work, please post the exact issue (exception details) you have faced.

edited Nov 13 at 6:51

dev ツ

6,83273781

answered Nov 13 at 5:09

Ajar

948

Thanks for the reply. I was running the command under hbase shell earlier. I tried running outside the shell and it worked.
– Manideep Reddy N
Nov 13 at 5:57

add a comment |

up vote
0
down vote

accepted

Using the following command has worked for me to achieve hbase table import in Sgoop:

If the solution does not work, please post the exact issue (exception details) you have faced.

edited Nov 13 at 6:51

dev ツ

6,83273781

answered Nov 13 at 5:09

Ajar

948

Thanks for the reply. I was running the command under hbase shell earlier. I tried running outside the shell and it worked.
– Manideep Reddy N
Nov 13 at 5:57

add a comment |

up vote
0
down vote

accepted

Using the following command has worked for me to achieve hbase table import in Sgoop:

If the solution does not work, please post the exact issue (exception details) you have faced.

edited Nov 13 at 6:51

dev ツ

6,83273781

answered Nov 13 at 5:09

Ajar

948

Using the following command has worked for me to achieve hbase table import in Sgoop:

If the solution does not work, please post the exact issue (exception details) you have faced.

edited Nov 13 at 6:51

dev ツ

6,83273781

answered Nov 13 at 5:09

Ajar

948

edited Nov 13 at 6:51

dev ツ

6,83273781

edited Nov 13 at 6:51

dev ツ

6,83273781

edited Nov 13 at 6:51

dev ツ

6,83273781

answered Nov 13 at 5:09

Ajar

948

answered Nov 13 at 5:09

Ajar

948

answered Nov 13 at 5:09

Ajar

948

Thanks for the reply. I was running the command under hbase shell earlier. I tried running outside the shell and it worked.
– Manideep Reddy N
Nov 13 at 5:57

add a comment |

Thanks for the reply. I was running the command under hbase shell earlier. I tried running outside the shell and it worked.
– Manideep Reddy N
Nov 13 at 5:57

Thanks for the reply. I was running the command under hbase shell earlier. I tried running outside the shell and it worked.
– Manideep Reddy N
Nov 13 at 5:57

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky