3 Replies Latest reply on May 10, 2018 12:56 PM by shawkins

    Hive import not working

    mahavird

      I have a hive schemas which I have to import into teiid.

      I have most of the schemas imported into teiid from hive.

      But when I import other two schemas It is not importing.

       

      My observation is ...

       

           1. This two non importing schemas have both table and view present in it. (But working schemas do not have views, only tables).

           2. If I specify both TABLE,VIEW in table types then also not working.

           3. Also the tables contain _ character in it. Is it the problem ?

           4. Also I am using schema pattern to import schema. Again schema with _ is the problem.

       

      But exactly I do not know what is the problem with importing these two schemas from hive.

      Kindly help.

       

      Regards,

      Mahavir

        • 1. Re: Hive import not working
          rareddy

          Mahavir,

           

          How are you importing the metadata? Using the Designer's Teiid Connecton Importer? Try setting the "useDatabaseMetaData" import property to "true" and see if that helps.

           

          Ramesh..

          • 2. Re: Hive import not working
            mahavird

            Hi Ramesh,

             

            Thanks for the reply.

            I am already setting useDatabaseMetaData to true, still I am getting this error.

             

            Regards,

            Mahavir

            • 3. Re: Hive import not working
              shawkins

              > I am getting this error

               

              What error/exception are you seeing?

               

              >  3.  Also the tables contain _ character in it. Is it the problem ?

              >  4. Also I am using schema pattern to import schema. Again schema with _ is the problem.

               

              That is not a problem for Teiid, but it is a like meta character, which may be causing an issue with the DatabaseMetaData implementation supplied with Hive.