Uploaded image for project: 'Access Server (READ-ONLY)'
  1. Access Server (READ-ONLY)
  2. ACCESS-255

sqoop import option is not working for importing Oracle tables

          Details

          • Type: Bug
          • Status: Open
          • Priority: Major
          • Resolution: Unresolved
          • Affects Version/s: 1.1.0
          • Fix Version/s: None
          • Labels:
          • Environment:
            Pivotal HD 2.1 with 2 name nodes and 4 data nodes

            Description

            sqoop list-databases, sqoop eval options are working well with Oracle

            but when I am running import option to create tables in hive is not working

            sqoop import --connect jdbc:oracle:thin:@tns_enty --username xxxxx --password yyyyy --table TABLE_DIM -m --hive-import

            This option is also not working

            sqoop create-hive-table --connect jdbc:oracle:thin:@tns_enty --username xxxxx --password yyyyy \
            --table TABLE_DIM --hive-table TABLE_DIM

              Attachments

                Activity

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    sunilbuge Sunil Buge
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: