DynamoDB : The provided key element does not match the schema

To query on fields which are not the hash key you need to use a Global Secondary Index (GSI). Take a look at this AWS Post for more details on GSI’s.

UPDATE Feb 2015: It is now possible to add a GSI to an existing table. See the Amazon Docs for more details.

Sadly you cannot add a GSI to an existing DynamoDB table so you’ll need to create a new table and port your data if this is something you really need to query on.

From the DynamoDB FAQ:

Q: How do I create a global secondary index for a DynamoDB table?

All GSIs associated with a table must be specified at table creation time. At this time, it is not possible to add a GSI after the table has been created. For detailed steps on creating a Table and its indexes, see here. You can create a maximum of 5 global secondary indexes per table.

If you do not want to port your data you could consider creating a second DynamoDB table with the email as a hash key and the hash of the parent record to use as a lookup into your main data table but as you can imagine this isn’t exactly an optimal solution and it comes with its own headaches of keeping it in synch with your master table.

Related Posts:

  1. boto3 client NoRegionError: You must specify a region error only sometimes
  2. Print string to text file
  3. How can I parse a YAML file in Python
  4. Cannot find module cv2 when using OpenCV
  5. Maximum and Minimum values for ints
  6. How is Anaconda related to Python?
  7. What is the python keyword “with” used for? [duplicate]
  8. What is the purpose of meshgrid in Python / NumPy?
  9. How to add to the PYTHONPATH in Windows, so it finds my modules/packages?
  10. FileNotFoundError: [WinError 2] The system cannot find the file specified:
  11. Remove all whitespace in a string
  12. What is a “method” in Python?
  13. How to generate all permutations of a list?
  14. Is there a Python equivalent to Ruby’s string interpolation?
  15. Python Progress Bar
  16. Most efficient way to find mode in numpy array
  17. Python error “ImportError: No module named”
  18. How to groupby based on two columns in pandas?
  19. How do I append one string to another in Python?
  20. Python Progress Bar
  21. Python List vs. Array – when to use?
  22. How to terminate a script?
  23. numpy array concatenate: “ValueError: all the input arrays must have same number of dimensions”
  24. csv.Error: iterator should return strings, not bytes
  25. SyntaxError: non-default argument follows default argument
  26. socket.error: [Errno 48] Address already in use
  27. Creating a basic auto clicker in python
  28. What’s the difference between torch.stack() and torch.cat() functions?
  29. proper name for python * operator?
  30. How to do superscripts and subscripts in Jupyter Notebook?
  31. How do I unload (reload) a Python module?
  32. SyntaxError: cannot assign to operator
  33. Using a comparator function to sort
  34. TypeError: ‘NoneType’ object is not iterable in Python
  35. Understanding slice notation
  36. Add list to set?
  37. Infinite integer in Python
  38. Determine Whether Integer Is Between Two Other Integers?
  39. If vs. else if vs. else statements?
  40. Quoting backslashes in Python string literals
  41. AttributeError: Can only use .dt accessor with datetimelike values
  42. Python string class like StringBuilder in C#?
  43. How do I clear all variables in the middle of a Python script?
  44. How do I combine two dataframes?
  45. How can I get list of values from dict?
  46. How do I append one string to another in Python?
  47. AttributeError: ‘list’ object has no attribute ‘replace’ when trying to remove character
  48. How to sort a list of objects based on an attribute of the objects?
  49. Normalize columns of pandas data frame
  50. Normalize columns of pandas data frame
  51. Python Error: “ValueError: need more than 1 value to unpack”
  52. Python: can’t assign to literal
  53. “Initializing” variables in python?
  54. How to convert bytearray to string in python
  55. Subtracting two lists in Python
  56. Is there any way to kill a Thread?
  57. BeautifulSoup getting href
  58. Equivalent of shell ‘cd’ command to change the working directory?
  59. What is PEP8’s E128: continuation line under-indented for visual indent?
  60. PyQt is thread-safe to the same extent that Qt is thread-safe. The Qt docs will tell you which parts of their API are guaranteed to be so, and under what circumstances.
  61. How to downgrade the installed version of ‘pip’ on windows?
  62. Where do I get a SECRET_KEY for Flask?
  63. What does |= (ior) do in Python?
  64. How can I find the first occurrence of a sub-string in a python string?
  65. NumPy List Comprehension Syntax
  66. Python socket.error: [Errno 111] Connection refused
  67. Windows- Pyinstaller Error “failed to execute script ” When App Clicked
  68. Python: What is the correct MIME type for attaching html file to email
  69. “Unorderable types: int() < str()"
  70. python : an integer is required (got type str)
  71. Django Rest Framework — no module named rest_framework
  72. Unsupported operation :not writeable python
  73. RuntimeError: Invalid DISPLAY variable
  74. bash: mkvirtualenv: command not found
  75. Convert a Unicode string to a string in Python (containing extra symbols)python string unicode type-conversion
  76. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  77. sqlite3.OperationalError: unable to open database file
  78. Object of type ‘map’ has no len() in Python 3
  79. How to uninstall jupyter
  80. Python CSV error: line contains NULL byte
  81. python NameError: name ‘file’ is not defined
  82. python BeautifulSoup parsing table
  83. Python Add to dictionary loop
  84. how to exit a python script in an if statement
  85. How to add column to numpy array
  86. OpenCV NoneType object has no attribute shape
  87. Printing subscript in python
  88. How to clear Tkinter Canvas?
  89. Python official installer missing python27.dll
  90. TypeError: ‘range’ object does not support item assignment
  91. Convert string to variable name in python
  92. Python regex match space only
  93. OpenCV houghLinesP parameters
  94. Generate a random letter in Python
  95. NameError from Python input() function
  96. How do I tell Matplotlib to create a second (new) plot, then later plot on the old one?
  97. Syntax highlighting in vim for python
  98. Python IOError: File not open for reading
  99. Flask Value error view function did not return a response [duplicate]
  100. AttributeError: ‘Series’ object has no attribute ‘split’ error in sending emails

Leave a Comment